Sqlservr.exe Consumes Most of Memory in SBS 2008- Open an Administrative command prompt.
- Type:
osql -E -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query - 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. - 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. - Type:
1> exit - Restart the service, or reboot the server. The database instance may be opened in the management applet using the above notation.
|