Systems Management Question

Small business server SQL using a lot of memory

12/09/2012 12225 views

SQL server on Sbs2011 is using majority of memory

0 Comments   [ + ] Show comments


All Answers


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

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ