OpsMgr 2007: Disk space monitoring of SQL DB file does not trigger an alert if DB is set to Autogrow


Here’s an interesting issue that was sent to me by Rohit Kaul on our OpsMgr 2007 team.  This one concerns an issue where the disk space monitoring of a SQL database file does not trigger an alert if the database is set to Autogrow:

========

Issue:  The disk space monitor for a SQL database file may not trigger an alert in Operations Manager admin console:

Monitor Name:         Db space free
Default Tareget:      SQL DB FILE

Cause: This can occur if the database to be monitored is set to Autogrow.

Resolution: To resolve this issue disable Autogrowth on the database in question:

1. Open SQL Management Studio if using SQL 2005 servers – SQL Enterprise Manager for SQL 2000 servers.

2. Expand SQL INSTANCE—Databases–choose the DB for which an alert is not getting triggered.

3. Right Click DB and choose properties and click FILE –under AUTOGROWTH COLUMN–click on Browse Button and uncheck ENABLE Autogrowth–click OK.

4. Re-cycle the Health service on the targeted server [SQL server in this case].

5. Refresh your OpsMgr console and check for disk space alerts for SQL DB FILE.

Note: Alerts may not show up until the configuration has been completely updated.  To verify this check for event IDs 1201 and 1210 on the targeted server.

========

Thanks Rohit!

J.C. Hornbeck | Manageability Knowledge Engineer

Comments (2)

  1. Merrill Aldrich says:

    This is really bad advice. Many people use autogrow on purpose, and it's important to find out what the implications are of turning it off. Simply switching it off can create a problem where there was none.

  2. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    http://showboxandroids.com/showbox-apk/
    http://showboxappandroid.com/
    Latest version of Showbox App download for all android smart phones and tablets.
    http://movieboxappdownloads.com/ – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    http://showboxappk.com/showbox-for-ipad-download/
    http://showboxappk.com/showbox-for-iphone/
    Showbox for PC articles:
    http://showboxandroids.com/showbox-for-pc/
    http://showboxappandroid.com/showbox-for-pc-download/
    http://showboxforpcs.com/
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings.
    http://www.showboxforipad.org/showbox-apk/ Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    http://www.showboxforipad.org/
    http://movieboxappdownloads.com/moviebox-apk-android/
    http://movieboxappdownloads.com/download-moviebox-pc/
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    http://showboxforiphone.org/
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    http://ymaillogintips.com/
    Sign Up & Do registration for latest movies on Showbox application