The RockSolid application allows you to change how long you are keeping data collected from the SQL Server instances within the data repository. Please see the settings topics on how to change these values:
- SETTING: RockSolid Job History Retention
- SETTING: RockSolid Performance History Retention
- SETTING: Aggregate RockSolid Performance History
RockSolid Data Removal Process
When you change the data storage parameters with RockSolid, on saving of the policy changes this may make a large amount of data within the RockSolid database expire. For example, if at a group policy you reduce a retention policy from 720 days to 365 days, this may make hundreds of millions of individual rows of data now outside the policy window. In order to ensure the removal of this data doesn't create a massive load on your database server, RockSolid will remove this data gradually.
The RockSolid data removal process uses a round-robin approach for each data feed repository, allocating a set amount of time per data feed and iterating over each data feed removing expired data in small batches (to avoid database contention). This process repeats continuously while the RockSolid services are running as the data in RockSolid is retained as a sliding window (i.e. as new data enters, old data leaves).
Depending on the volume of data that is expired, the removal of this data may take several hours or in some cases days or weeks. This is expected behaviour as the risk of attempting to do this in a more aggressive manner may lead to resource contention, delaying the import of newly monitored data into the RockSolid repository.
If you however are experiencing a capacity issue and need to remove data faster than what is occurring with the default clean up process, please contact RockSolid support who can assist.