By default, the retention period for data being stored within Reporting Data Warehouse are:
| Data Set | Aggregation Type | Retention Period (Days) |
| Alert | Raw data | 400 |
| State | Raw data | 180 |
| State | Hourly aggregations | 400 |
| State | Daily aggregations | 400 |
| Event | Raw data | 100 |
| Aem | Raw data | 30 |
| Aem | Daily aggregations | 400 |
| Perf | Raw data | 10 |
| Perf | Hourly aggregations | 400 |
| Perf | Daily aggregations | 400 |
To modify the grooming settings for Alerts data in OpsMgr Reporting Data Warehouse:
- Login to SQL Server Management Studio and connect to the SQL Server Instance that hosts your Reporting Data Warehouse
- Expand the Databases -> OperationsManagerDW -> Tables node
- Right click dbo.DataSet and select Open Table
- On the returned result, locate the dataset that you would want to modify by referring to the value in DataSetDefaultName field in this case it will be "Alert dataset" and get the DataSetId field for that particular row which in this case will be "69baaa10-055f-4f56-9a03-4312dd2b6406" as depicted in the picture below.
- Right click on dbo.StandardDatasetAggregation and click Open
- In the returned results, locate the row which has the DataSetId value that matches the one you got earlier which in this example will be "69baaa10-055f-4f56-9a03-4312dd2b6406"
- You can change the retention period of alert data by setting the value of MaxDataAgeDays field of the corresponding row
