- Is it possible to change the retention policy of SQL Server and Oracle Performance Investigator (SQL PI)?
- Is there a way to monitor SQL PI repository growth?
- Can SQL PI repository database data be purged?
When PI is not enabled, what is the retention policy for database agent metrics?
When PI is not enabled, the database agent metrics are stored in the FMS repository, which follows the policy in the FMS.
In this example, for Blocking History, the agent is 3 days.
What is the retention policy for SQL PI database agent metrics when PI is enabled?
When Pi is enabled, PI metrics are sampled by PI engine and stored in the PI repository, so it does not follow the FMS policy.
In this way the retention policy for blocking history metrics (as an example) should follow this table:
|1 minute||6 hours|
|15 minutes||3 days|
|1 hour||2 weeks|
|6 hours||30 days|
|1 day||90 days|
|1 week||2 years|
So theoretically the oldest data could be kept in repository for 2 years, then purged by our manager agent
Is it possible to change the retention policy of SQL Server Performance Investigator and Oracle Performance Investigator (SQL PI)?
It is currently not possible to change the retention policy of SQL PI.
Is it possible to purge data from the SQL PI repository?
It is not possible to purge data from the SQL PI repository from the Foglight FMS UI.
Data can be manually removed from the PI repository based on the instance ID (i.e. agents) and dates however this process is not support. Professional Services (PSO) may be able to assist with this process.
Is there a way to monitor SQL PI repository growth & can SQL PI repository database data be purged?
There is no out-of-the-box monitoring of the PI repository. Options may include the following: