Setting the Maximum Memory Usage on SBSMonitoring 11

Susan Bradley had an often-referenced post on how to adjust the maximum memory usage of the SBSMonitoring MSDE instance in SBS 2003. Surprise, the SBSMonitoring database in SBS 2008 can also grow exceedingly large if not kept in check. The memory limits for the SBSMonitoring database can be adjusted in the SQL 2005 Management Studio Express on an SBS 2008 server. Here are the steps to do that:

  1. On the SBS 2008 server, open the Start menu and select All Programs.
  2. Select Microsoft SQL Server 2005.
  3. Right-Click on SQL Server Management Studio Express and select Run As Administrator. If you don’t run the tool as Administrator, the remaining steps will not work.
  4. Select the database from the drop-down list, or enter it as servernameSBSMONITORING, then click Connect.
  5. When the Object Explorer window opens, right-click on the top item (servernameSBSMONITORING) and select Properties.
  6. Click on the Memory page in the left-hand column.
  7. Change the Maximum Server Memory value to something a little more reasonable (100 has been bantered around as a reasonable value, but you may need to adjust depending on the server performance).
  8. Click OK and the database memory usage will be adjusted.
  9. Close SQL Server Management Studio Express when finished.

Want to see this in action? Check out our screencast of the process!

Leave a comment

Your email address will not be published. Required fields are marked *

11 thoughts on “Setting the Maximum Memory Usage on SBSMonitoring

  • Sam

    Good tip. You would think that they would throttle it a little on low memory systems anyway. I did a fresh install on a 6gb system and right off the bat it was chewing up 1.5gb, which in turn made everything dog slow. I did this tweak and rebooted and everything came back to life. Thanks

  • Tom

    This is much better than the process using OSQL.

    Thanks for the tip. For those running SBS 2008 on 6GB systems, you really should be running on at least 8GB. At least that is what I was told.

  • Dim

    We had a server with 8gb ram and sbsmonitoring was using most of the time 1.5-2gb of ram..making the server very slow with no reason.. trying your tip boosts the performance back to normal and now it is using 300-400mb of ram only.

    Thank you

  • Pingback: SBS2011 Disabling SharePoint Because Of Problems | Click & Find Answer !

  • Pingback: IIS High use & Server Performance issues | You need? We have! Everything

  • Og

    This didn’t work for me. I had to also edit the max memory on the instance of the db, not just the the db.

    Logging into this DB name via the SQL Server Management Studio Express and then following the above steps for the instance did work.