Configuring CA Executive Insight › Purging Data from the CA Executive Insight Database

Purging Data from the CA Executive Insight Database

Over time, the data in the CA Executive Insight database can become huge. To reduce the amount of data stored in the database, CA Executive Insight purges expired data from the database every day based on a specified retention criteria. For example, if the data retention criteria is 100, all data older than 100 days are deleted from the database. The data purge usually occurs daily, after midnight; however, it can also occur at the re-start of the CA Executive Insight server if the last purge process didn't complete successfully.

The retention criteria are stored in the CA Executive Insight database in the tenant_settings table as follows:

rawDataRetentionDays

Specifies the raw data retention criteria in days.

Default: 3

Limits: 1 or greater

hourlyDataRetentionDays

Specifies the hourly aggregated data retention criteria in days.

Default: 14

Limits: 7 or greater

dailyRetentionDays

Specifies the daily aggregated data retention criteria in days.

Default: 730

Limits: 90 or greater

To change the retention criteria, you can use an SQL update query. For example, the following query sets the daily aggregated data retention criteria to 100 days:

UPDATE tenant_settings SET value=100 WHERE  id=3;

For the change to take effect, you must restart the CA Executive Insight server. At server startup, the retention criteria values are validated. If a value is less than its minimum value, the default value is used and an error message is displayed in the CA Executive Insight server log.