Sqlservr.exe Consumes Most of Memory in SBS 2008

1. Open an Administrative command prompt.

2. Type:

   osql -E -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

3. At the prompt, type:

   1> sp_configure 'show advanced options',1

   2> reconfigure with override

   3> go

   The screen displays:

   Configuration option 'show advanced options' changed from 0 to 1. Run the
   RECONFIGURE statement to install.

4. Type:

   1> sp_configure 'max server memory', 512

   2> go

   (NB The RAM usage of 512Mb is a suggestion, use whatever is appropriate in your environment.)

   The screen displays:

   Configuration option 'max server memory (MB)' changed from 2147483647 to 512.
   Run the RECONFIGURE statement to install.

5. Type:

   1> exit

6. Restart the service, or reboot the server. The database instance may be opened in the management applet using the above notation.