KB ID 0000190 Dtd 01/03/10
Problem
Seen on SBS 2008 with WSUS.
The Windows internal database (the one used by WSUS) has no memory reservation limit, so it can use as much as it wants, this is a BAD thing!
Your server will struggle because the following consumes to much memory.
SQL/MSSQL$MICROSOFT##SSEE
Solution
1. Click Start > In the search/run box type CMD {enter}.
2. At command line issue the following commands,
sqlcmd -S .pipemssql$microsoft##sseesqlquery -E sp_configure ’show advanced options’, 1; reconfigure; go sp_configure ‘max server memory’, 512; reconfigure; go exit