Friday 23 November 2012

SBS 2008 sqlservr.exe - MSSQL$MICROSOFT##SSEE high memory usage

What:

Microsoft SQL Server on Windows Small Business Server 2008

Problem:

Microsoft SQL Server is using huge amount of memory, makes server slow and unresponsive.

Solution:

This is a second post with a similar issue, first one was with regards to SBS monitoring

Use the same technique to get all the information about sqlservr.exe process.
Data base mdf and ldf files are located at:
C:\WSUS\SUSDB\UpdateServicesDbFiles
 SUSDB.mdf in my case is 10GB in size.

One way of maintaining that database and keeping in a good condition is running Server Cleanup Wizard.
Open up Server Manager > Windows Server Update Service
Alternatively:
Start > Run > mmc
Add "Update Services" snap-in, go to options and run cleanup wizard.

Unfortunately it will not reduce the size of a SUSDB file, but it will reduce WSUS folder size as it removes expired/unused updates.
If you have a small network, let's say 5 computers then I would say remove Windows Server Update Service role from your server, it's not worth it (make sure it will not brake anything, do your research)

How to reduce SUSDB.mdf size? It seems that best way is to build a new database.


Scripts which may help:
http://gallery.technet.microsoft.com/scriptcenter/6f8cde49-5c52-4abd-9820-f1d270ddea61
http://community.spiceworks.com/scripts/show/336-wsus-automatic-cleanup-script

For now I decided to disable WSUS services.

Related post:
Shrink huge WSUS content folder in SBS 2008/2011

1 comment:

  1. Thank you. You saved me a heap of time!

    ReplyDelete