Slow SBS 2008/2011 server - but memory and CPU look fine

Corrupt SBS Monitoring Database.

Have a look in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\. If SBSMonitoring.mdf or SBSMonitoring_log.ldf are large, we can replace them with empty, fresh versions; quite often this will sort out your performance issues, a corrupt database is often the cause.

To install your new clean database, please follow these steps:

  1. Run services.msc.
  2. Stop the Windows SBS Manager Service and SQL Server (SBSMONITORING) services.
  3. Delete (or rename if you want to keep) the two following files: (if not found, try Program Files (x86))
    1. C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SBSMonitoring.mdf 
    2. C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SBSMonitoring_log.ldf
  4. Download the attached file.
  5. Unzip the zip file and copy those two files into the folder above.
    Note: you don’t need to do detach or attach database in SQL Management Studio, the fresh database is already tuned.
  6. Start the SQL Server (SBSMONITORING) service.
  7. Start the Windows SBS Manger Service.
Have more questions? Submit a request