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:
- On the SBS 2008 server, open the Start menu and select All Programs.
- Select Microsoft SQL Server 2005.
- 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.
- Select the database from the drop-down list, or enter it as servernameSBSMONITORING, then click Connect.
- When the Object Explorer window opens, right-click on the top item (servernameSBSMONITORING) and select Properties.
- Click on the Memory page in the left-hand column.
- 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).
- Click OK and the database memory usage will be adjusted.
- Close SQL Server Management Studio Express when finished.
Want to see this in action? Check out our screencast of the process!