none
SQLserver.exe memory usage 4GB

    Question

  • Hi

    Is there anyway to cap this memory usage ?

    I believe that the MSSQL$MICROSOFT##SSEE service is causing this .

    I have followed the steps in this blog, however it doesn't appear to affect the memory usage, even after Restarting the Windows Internal database (MICROSOFT##SSEE) service.

    Please advise what I need to do.

    Thanks

    Below is a screen shot of the SQLserver.exe memory usage after restarting the service. It will start to then creep slowly upto 4GB , where is will then remain at this size until the service is restarted

    Thursday, July 26, 2012 9:21 AM

Answers

  • You're trimming the wrong SQL instance by the looks of it. MSSQL$MICROSOFT##SSEE is WSUS, not the monitoring instance.

    Take a look at these instructions - I did exactly the same for the WSUS (MSSQL$MICROSOFT##SSEE) instance on SBS 2011 two days ago and it worked instantly:

    http://msmvps.com/blogs/bradley/archive/2010/11/08/throttling-the-memory-in-sbs-2008.aspx

    You need to use the specific syntax to access the WSUS instance:

    \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

    I also used this syntax to trim the monitoring and sharepoint instances too - replacing the MSSQL$MICROSOFT##SSEE with the correct instance name as listed by tasklist /svc

    • Marked as answer by uklogistics Friday, July 27, 2012 8:37 AM
    Friday, July 27, 2012 8:23 AM

All replies