Database Size

MOM stores all data and configuration information in the Microsoft SQL Server 2000 (OnePoint) database. The MOM database can grow very large, particularly in environments where MOM collects significant amounts of data, or monitors a large number of computers. MOM supports a maximum database size of 30 GB. You must maintain at least 40 percent free space to allow indexing and database jobs to complete successfully.

To maintain the optimum database size, MOM periodically grooms data from the MOM database. When MOM grooms data, you can lose performance, alert, event, security, and capacity planning data. You might want to retain this historical data for a number of business reasons, such as long-term security auditing or capacity planning.

To retain historical MOM data, while keeping the MOM database at optimum levels, you can create a MOM Reporting database. For more information, see Chapter 5, "Deploying MOM 2005 Reporting", and Chapter 7, "Deploying MOM 2005 in Advanced Environments", in the Microsoft Operations Manager 2005 Deployment Guide.