Completion of these steps will free up a lot of resources on an SBS. You will need to have a different method (e.g., Labtech, many others) to keep client machines up to date.
- Run (install first if not present) the SQL Server Management Studio.
- Connect the Studio, to type Database Engine, server name
\\.\pipe\mssql$microsoft##ssee\sql\query
- In the Studio, under Databases, you will find an item “SUSDB”.
- If you don’t know where the database files are held, find them using the properties of that item.
- Run an SQL query to get a list of connections:
EXEC sp_who2
- Run SQL query/ies to kill all connections to DBName SUSDB only, using the SPIDs, e.g.,
KILL 999
- Right-click SUSDB, “Delete” SUSDB, and close the Studio.
- Delete the database files and all of the update files.
- Disable the WSUS-related items in services.msc and IIS.
The above is digested from the following:
http://blog.mpecsinc.ca/2011/07/sbs-2011-wsus-sql-memory-usage-is-very.html