Home / server / Questions / 72566
In Process
Bastien974
Asked: 2009-10-09 07:01:45 +0800 CST

sqlservr.exe always reading SBSMonitoring.mdf

  • 772

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.

windows-sbs-2008

3 Answers

  1. 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.

    • 2

  2. 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

    • 0

  3. 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.

    • -1