Alert: Ops DB Free Space Low

Issue: The Operations Database for OpsMgr 2007 has less than 40% free space available.

Resolution: The OperationsManager database was not large enough to provide seven day (default) retention for the number of agents being monitored. Increased the size of the OperationsManager database using the SQL Server Management Studio (install it on the system running the OpsMgr console for ease of use). Connect to the server running the OpsMgr Operational Database (shown in the alert), open the server/databases, right-click on the OperationsManager database (default name) and click properties. Click on the files tab, change the MOM_DATA size to the new size and click Ok. You can validate that the change in size occurred by going back to the properties of the database. The alert will resolve itself in Operations Manager within approximately 15 minutes if enough free space is available as this monitor is defined to a 900 second frequency.

Submitted By: Cameron Fuller (MVP)