In SBS 2003 or SBS 2008 you will experience system hangs, general slowdowns with users logging in and slow authentication times. You may also see a large proportion of system memory consumed by SQL/MSSQL$MICROSOFT##SSEE service running in task manager.
By default this database is set to use whatever memory is available and can cause various problems.
Follow this simple guide put a limit on what memory this database can use..
- First we need to conect to the database so we can modify it. To do this launch SQL management studio express.
- We need to connect to\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query3. When connected you will see this screen.
4. Right click over the “top level” of the tree and select properties.
5. You will now see the properties section. Select memory , you will see its at 2TB, restrict it to whatever memory you want it to use, in my case its 4GB.
6.Apply these changes and give the server a reboot.