fixes small business server SQL windows server

SBS 2008 Sqlservr.exe High Memory Usage

Open an Administrative Command Prompt.

Type:
osql -E -S \.pipeMSSQL$MICROSOFT##SSEEsqlquery

Now at the SQL 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.

9 thoughts on “SBS 2008 Sqlservr.exe High Memory Usage

  1. If sqlservr.exe is using huge amount of memory there is a reason behind. Forcing it to use less memory doesn't solve the problem.
    You should check files in C:WSUSSUSDBUpdateServicesDbFiles as they are probably huge.

  2. but i have 2 sql proccess. one of them is x32. it solved only in one proccess. how can i change the ather one?
    it's sbs server 2008

Leave a Reply