Skip to Main Content
Essential Microsoft Operations Manager
book

Essential Microsoft Operations Manager

by Chris Fox
February 2006
Intermediate to advanced content levelIntermediate to advanced
384 pages
10h 37m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Getting Started with Microsoft System Center Operations Manager

Getting Started with Microsoft System Center Operations Manager

Kevin Greene
System Center 2012 Operations Manager Unleashed, 2nd Edition

System Center 2012 Operations Manager Unleashed, 2nd Edition

Kerrie Meyler, Cameron Fuller, John Joyner

Publisher Resources

ISBN: 0596009534Catalog PageErrata