Essential Microsoft Operations Manager

Chapter 7. MOM 2005 Database Fundamentals

The operational database is the choke point of every MOM 2005 management group. Before an alert is displayed in the Operator console, it is first written to the database. Before a notification on an alert can be sent, it goes through the database. The Operator console is a giant filter for all of the agent-collected information in the database. The Administrator console can’t administer the management groups’ configuration settings without interacting with this database.

The health of this database directly impacts the performance and health of the MOM 2005 management group. The MOM OnePoint database , which is the actual name of the operations database, doesn’t operate alone. Other databases on the management groups’ SQL Server perform supporting roles, so management group health is dependent on these as well.

This chapter teaches you how these databases interact, how to maintain them, and how to protect them (through backup and restore). It also addresses the functions and maintenance of the databases involved with MOM 2005 Reporting.

This chapter does not go into detail about SQL Server administration, but rather presents some the basic SQL Server tools and database administration tasks that will be relevant to the MOM 2005 administrator.

Chapter 2 covered the sizing exercises that are necessary for the installation of the OnePoint database. Basically, this is to calculate the amount of data flowing into the database on a daily basis and ...