Ops DB Free space low - Database set to autogrow...
My Ops DB is set to autogrow on our remote SQL server, however I am getting a warning that the DB free space is low...Is there anything that can be done to mitigate this? Why does it not update the database size when I go to the Database state monitor within the Microsoft SQL Server MP? Thanks!
June 27th, 2011 11:31pm

The recommendation is to not use auto-grow on the operations db. Also, make sure you have updated your SQL MP to the latest version - which added good support for autogrow space calculations. If the latest SQL MP is present and the disk is a raw mount point, then this scenario is still not handled perfectly based on other forum customer input. The reason you don't want to set the OpsDB to auto-grow is it will become fragmented. The way the DB is used is friendly to fixed sizing - and you should calculate the correct size based on the sizing guide document that is found elsewhere. Since the DB is groomed regularly, there is a size that it should not go above for a given MP count. When you set a DB to auto-grow, it can become fragmented and queries and access times go much slower. If there are too many partitions, this becomes increasingly noticeable.Microsoft Corporation
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 3:07am

In addition, I would like to share the following with you for your reference: OpsMgr 2007: Disk space monitoring of SQL DB file does not trigger an alert if DB is set to Autogrow http://blogs.technet.com/b/smsandmom/archive/2008/12/16/opsmgr-2007-disk-space-monitoring-of-sql-db-file-does-not-trigger-an-alert-if-db-is-set-to-autogrow.aspx SQL Database – To Grow or Not to grow http://systemcentersolutions.wordpress.com/2009/11/13/sql-database-to-grow-or-not-to-grow/ Please Note: Since the website is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information. Hope this helps. Thanks.Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
June 30th, 2011 6:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics