SQL server on Sbs2011 is using majority of memory

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

High SQL memory usage on SBS is almost always tied to WSUS. There are some pretty quick steps you can go through to resolve the issues.

  1. Open Task Manager –> Processes tab.
  2. View –> Choose Columns –> PID, Memory, etc.
    Now, in your task manager, the offending sqlserver.exe process should provide you a PID.
  3. Next, go to Start –> CMD –> Right click and Run As Admin.
    Type "tasklist /svc" and hit [Enter]
  4. Scroll through the resulting list and find the PID. Note the SQL Instance name associated with it
  5. Next, go to Start –> All Programs –> Microsoft SQL Server 2008 R2 –> Right click and Run as Admin on SQL Server Management Studio.
    Set: Server type: Database Engine.
    Set: Server name: \\.\pipe\mssql$microsoft##ssee\sql\query
    Copy and paste the above.
    Set: Authentication: Windows Authentication.
    Click Connect.
  6. Right click the root node (\\.\pipe\mssql$microsoft##ssee\sql\query) and left click on Properties.
  7. Click Memory.
  8. Change the amount of memory that WSUS can use. I typically do not set that higher than 2 to 4GB.

You should see a vast improvement with the SQLServer.exe process on your SBS2011 server.

 

 

 

 

Answered 12/13/2012 by: matthall
Purple Belt

Please log in to comment
Answer this question or Comment on this question for clarity