How to Change Grooming Settings in the Reporting Data Warehouse in Operations Manager 2007
Applies To: Operations Manager 2007 R2
Grooming settings for the Reporting data warehouse in Operations Manager 2007 are changed by using Microsoft SQL Server Management Studio to open the StandardDatasetAggregation table. Datasets in the StandardDatasetAggregation table are listed by a GUID. You open the Dataset table to match a dataset name with its GUID.
Any updates to the grooming settings are applied immediately.
To change grooming settings in the Reporting data warehouse
On the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
In the Connect to Server dialog box, in the Server Type list, select Database Engine, in the Server Name list select the server and instance for your Reporting data warehouse (for example, computer\INSTANCE1), in Authentication list, select Windows Authentication, and then click Connect.
In the Object Explorer pane, expand Databases, expand OperationsManagerDW, and then expand Tables.
Right-click dbo.Dataset, and then click Open Table.
Locate the dataset for which you want to change the grooming setting in the DatasetDefaultName column and make note of its GUID in the DatasetId column.
In the Object Explorer pane, right-click dbo.StandardDatasetAggregation and then click Open Table.
In the DatasetId column, locate the dataset GUID you noted in step 5. Multiple entries of the same GUID might display.
Locate the aggregation type from the list in the AggregationTypeId column by using the following values:
0 = raw, non aggregated data
10 = subhourly
20 = hourly
30 = daily
After you have located the dataset and its aggregation type, scroll to the MaxDataAgeDays column, and then edit the value there to set the grooming interval.