Massively high disk usage that comes with the SQL SBSMONITORING instance on SBS2008 and SBS2011.
You can’t get around this by simply disabling the SQL service, which solved the issue in the short term, but it is there for a reason and some programs require it such as backup programs in order to get a full 100% backup and so it needs to be running.
As you can see the ‘Read’ column and how high the sqlservr.exe image is compared to everything else. I know it only say’s 2 MB/sec Disk I/O but it’s the amount of Read (B/sec) which kills the disk speed, with the heads constantly jittering about reading data.
(This particular sqlservr does relate to the SBSMONITORING instance, if you hover your mouse over it’ll expand and show you the name.)
Basically the Database needs to be rebuilt, and luckily enough there is a nice little script to do this which you can find here:
Once you’ve downloaded this expand the contents extract the files to a ‘temp location’ then following the steps below depending on your Server edition:
NOTE: For this script to run without error you’ll need to stop the SQL Server (SBSMONITORING) and Windows SBS Manager Services. Or you can open up the Create-SBSMonitoringDb.ps1 script and add –force to the following lines as per below:
Stop-Service DataCollectorSvc -force
Stop-Service ‘MSSQL$SBSMONITORING’ –force