Grooming the MOM Database

  • Article

Database grooming refers to the process of deleting data from the MOM database and automatically resolving alerts. The grooming process is a SQLSERVERAgent batch job that resolves alerts or deletes the collected events, alerts, performance counters, and other events from the database. When customizing your grooming jobs, it is important to remember the following:

  • Ensure sufficient lag time between grooming jobs to allow for growth and event storms.

  • More data in your database results in longer grooming cycles. Query the MOM database to determine how many alerts and events are waiting to be groomed out of the database, and adjust the grooming settings accordingly.

  • Configure an alert rule to automatically alert you of grooming job failures.

Entering New Grooming Jobs

MOM does not allow you to enter new grooming jobs through the MOM Administrator console. You can only set the number of records to delete per grooming job, and set the age of the records being removed. However, you can use SQL Server Enterprise Manager to create a custom grooming job. For more information about custom grooming jobs, see the SQL Server 2000 documentation.

Scheduling Grooming Jobs

You can change the default settings for grooming jobs using SQL Server Enterprise Manager.

Caution

If you change the default scheduled times for database grooming, the new times must not interfere with other scheduled MOM tasks. For example, do not schedule a database grooming job for 2:05 A.M., because this is the default time to scan for managed computers.

To modify scheduled database jobs

  1. Log on with a Windows 2000 Administrator account to the computer on which you installed the database.

  2. From the Microsoft SQL Server folder, open Enterprise Manager.

  3. Expand SQL Server Group, and then expand the server that contains the MOM database.

  4. Expand Management, and then expand SQL Server Agent.

  5. In the left pane, click Jobs.

  6. In the right pane, right-click the job that you want to reschedule, and then select Properties.

  7. Click the Schedules tab.

  8. In the Properties window, click Edit.

  9. In the Edit Job Schedule window, click Change.

  10. In the Edit Recurring Job Schedule window, enter the values you want, and then click OK.

  11. In the Edit Job Schedule window, click OK.

  12. In the Properties window, click OK.