Welcome to Aquilaweb

MVP David Allen's weblog advising on
System Center Operations Manager

Grooming the OperationsManagerDW Database

Unfortunately there is no UI to configure the grooming settings of the DW which means you have to manually alter the default grooming settings in the DW database. The settings are stored in the StandardDatasetAggregation table which you can view by running the following SQL query.


SELECT AggregationIntervalDurationMinutes, BuildAggregationStoredProcedureName, GroomStoredProcedureName, MaxDataAgeDays, GroomingIntervalMinutes FROM StandardDatasetAggregation


The colum you are most likely to update is MaxDataAgeDays as this holds the data retention period (in days), obviously lowering this is a quick and easy way to reduce the size of the database.


Here's a sample script to update the data retention period for Event data:
UPDATE StandardDatasetAggregation SET MaxDataAgeDays = (retention period in days) WHERE GroomStoredProcedureName = 'EventGroom'

18 Feb, 2008 | David

Comments

As for me it is a very useful post.

Ryder - 29 Dec, 2009 - 18:13:57
--------------------------

Leave comment