WSUS 3.0 memory usage and how to adjust it

I set up a new Windows 2003 R2 Small Business Server (SBS) last week and I'm going over it and tweaking things.

While looking at the task manager, I noticed a process that was using 1.6 GB of RAM. This sqlserver.exe process was going wild!

I turned on the process IDs in Task Manager (View > Select Columns) so I could get a process ID for the offending process. For me, it was process id 1664. Then, I turned to the console for some troubleshooting:
C:\tasklist /svc /fi "PID eq 1664"
You should change your process id to match if you're running this at home.
Image Name                     PID Services
        ========================= ======== =======================
        sqlservr.exe                  1664 MSSQL$MICROSOFT##SSEE
 Microsoft SSEE shows in the services panel as Windows Internal Database, which is the database for Windows Software Update Services. Now that we know the instance name, we can reconfigure it:

C:\osql -E -S <servername>MICROSOFT##SSEE
        1> sp_configure ’show advanced options’, 1;
        2> reconfigure;
        3> go
        Configuration option ’show advanced options’ changed from 0 to 1.
          Run the RECONFIGURE statement to install.
        1> sp_configure ‘max server memory’, 512;
        2> reconfigure;
        3> go
        Configuration option ‘max server memory (MB)’ changed from
          2147483647 to 512. Run the RECONFIGURE statement to install.
        1> exit</servername>

While you're at it, you may want to reconfigure the SBSMONITORING database instance if you're running SBS. I set mine to 70 MB.

Established 2005 · Databasically © 2016