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:
- Run services.msc.
- Stop the Windows SBS Manager Service and SQL Server (SBSMONITORING) services.
- Delete (or rename if you want to keep) the two following files: (if not found, try Program Files (x86))
- C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SBSMonitoring.mdf
- C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SBSMonitoring_log.ldf
- Download the attached file.
- 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.
- Start the SQL Server (SBSMONITORING) service.
- Start the Windows SBS Manger Service.