Configure grooming settings for the Reporting data warehouse database
The Reporting data warehouse 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). The database is set up to delete older data in order to maintain performance by managing its size. Deleting the older data is called grooming.
The following table highlights the default data types and retention period after initial setup of the data warehouse database.
| Dataset | Aggregation Type | Retention Period (in days) |
|---|---|---|
| Alert | Raw | 400 |
| Client Monitoring | Raw | 30 |
| Client Monitoring | Daily | 400 |
| Events | Raw | 100 |
| Performance | Raw | 10 |
| Performance | Hourly | 400 |
| Performance | Daily | 400 |
| State | Raw | 180 |
| State | Hourly | 400 |
| State | Daily | 400 |
Settings for grooming the data warehouse can be changed through Microsoft SQL Server Management Studio.
Change grooming settings in the Reporting data warehouse
Sign in to the computer with an account that's a member of the SQL Server sysadmin fixed server role.
On the Start Page, enter SQL Server Management Studio and the program will appear. Select the program to open SQL Server Management Studio. You might want to right-click the program and pin it to the Start Page.
In the Connect to Server dialog, 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 select Connect.
In the Object Explorer pane, expand Databases, expand OperationsManagerDW, and then expand Tables.
Right-click dbo.Dataset, and select 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 select 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, nonaggregated data
10 = subhourly
20 = hourly
30 = daily
After you've located the dataset and its aggregation type, scroll to the MaxDataAgeDays column, and then edit the value there to set the grooming interval.
Next steps
To learn more about the default retention period for the different data types stored in the Operations Manager operational database and how to modify those settings, see How to configure grooming settings for the Operations Manager database.