3

I'm having an issue with my sqlservr.exe which is always reading the SBSMonitoring.mdf, around 50MB/sec. I saw that in Reliability and Performance mmc. I don't think my hard drive love it... and it slows down my server. We have a SBS 2008.

I found nothing about it, help me please :) Thanks.

Bastien974
  • 1,886

3 Answers3

2

I had the same issue and posted to Microsoft's SBS Community forum. I was directed to Microsoft Knowledge Base article 981939 which seems to have fixed my problem without disabling the monitoring.

The article includes a powershell script to reduce the amount of monitoring data that is kept from 90 days to 30 days and adds some indexes and statistics to the database.

Jim Clark
  • 198
0

SBS Monitoring looks like a beast. I've found two links for you to look at:

I hope these help. You might want to look at either turning this off, or configuring it to use fewer resources. 50MB/s sounds like your drive is exclusively doing this monitoring.

EDIT: Here's another link. This may be more useful:

http://technet.microsoft.com/en-us/library/cc708152(WS.10).aspx

-1

If you aren't using the monitoring disable it. It sounds like you are monitoring a ton of stuff. You can also check the database in SQL Server and make sure that it's not set to autoclose the database which would add to the problem.

mrdenny
  • 27,212