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.
J.C. Hornbeck | Manageability Knowledge Engineer