SBS 2008 Sqlservr.exe High Memory Usage

Open an Administrative Command Prompt.

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

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.


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.


1> exit

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


  1. hats of for you Daniel B.
    such a good, short, and comprehensive description of using high memory..
    keep it up

  2. Thanks! - Worked like a Charm

    - SPN

  3. Great Man, good solution.

  4. This worked for me too. Thanks Daniel

  5. 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:\WSUS\SUSDB\UpdateServicesDbFiles as they are probably huge.

  6. Wow, so simple, yet so effective

  7. 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


Post a Comment

Popular posts from this blog

Office 365 ScanPST to fix corrupted Outlook files

Deleting Office 365 Tenant

HP LaserJet P3005 Cold Reset