THE OPERATIONS DATABASE
The Operations Manager database keeps data for a period of 7 days by default, these settings can be adjusted in the console as follows:-
- In the Operations console, click Administration.
- In the navigation pane, expand Administration, and then click Settings.
- In the Settings pane, right-click Database Grooming, and then click Properties.
- In the Global Management Group Settings – Database Grooming dialog box, select a record type, and then click Edit.
- In the dialog box for the record type, specify Older than days, and then click OK.
In the Global Management Group Settings – Database Grooming dialog box, select another record type to Edit or click OK
THE DATAWAREHOUSE DATABASE
The Datawarehouse database stores data for a specified length of time, depending on the data (Alert, State, Event, Aem, or Performance) and the aggregation type (raw data, hourly aggregations, daily aggregations). These default retention periods range from 400 days to 10 days.
These aforesaid retention periods can be changed in 2 ways:-
1.Using a tool called DWDataRP.exe
2.Manually using SQL Server Management Studio
If you want to use the DWDataRP.exe tool, Kevin Holman has written a brilliant concise post on his blog which can be found here:-
To change these settings manually via SQL Server Management Studio do as follows:-
- On the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2008, 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
9. 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.