# Database Retention Periods

> Set how long the backend and other PerformanceGuard databases keep their data.

Source: https://docs.capaone.com/performanceguard/administration/more-setup/database-retention-periods/  
Product: PerformanceGuard — a separate CapaSystems product; do not apply this page to any other.

You can define database retention periods (that is how long databases should keep data) in the PerformanceGuard web interface:

:::caution
You can only do this if you're a PerformanceGuard administrator.
:::

# **Backend Database**

Select **ADMINISTRATION > Setup > Parameters** ad then select the **Status** tab.

Alternatively, you can define backend database retention parameters directly in the database if you edit the *Value* column of the *Status* table. SQL example:

:::note[Important]
use pguard

update pguard.status set value='600' where parameter='KEEP\_PERIOD\_AGGREGATE\_DATA'
:::

The backend server schedules and executes data deletion jobs according to these values. Any parameter value changes will take effect immediately. The following is a non-exhaustive list of parameters:

- **KEEP\_PERIOD\_AGENTS**  
    
  Data from PerformanceGuard agents that haven't been online during this period will be deleted from the database.   
    
  Unit: Hours  
    
  Default value: 336 (336 hours = 14 days = two weeks)  
    
  This parameter won't have any effect if you set it lower than the lowest value of the parameters *KEEP\_PERIOD\_AGGREGATE\_DATA*, *KEEP\_PERIOD\_TRANSACTION\_DATA* or *KEEP\_PERIOD\_CITRIX\_AGGREGATE\_DATA*.

- **KEEP\_PERIOD\_TREND\_DATA**  
    
  All performance data aggregated at trend level (hours) will be deleted after this period.  
    
  Unit: Days  
    
  Default value: 470 (470 days = 15,4418 months = 1.25 years)

- **KEEP\_PERIOD\_TRANSACTION\_DATA**  
    
  Performance data related to transaction filters aggregated at agent group level will be deleted after this period.  
    
  Unit: Hours  
    
  Default value: 1488 (1488 hours = 62 days = two 31-day months)

- **KEEP\_PERIOD\_CITRIX\_AGGREGATE\_DATA**  
    
  Citrix session performance data will be deleted after this period.  
    
  Unit: Hours  
    
  Default value: 1488 (1488 hours = 62 days = two 31-day months)

- **KEEP\_PERIOD\_BTM2\_DATA**  
    
  Business Transaction Monitoring performance data aggregated at agent group level will be deleted after this period.  
    
  Unit: Hours  
    
  Default value: 1488 (1488 hours = 62 days = two 31-day months)

- **KEEP\_PERIOD\_BTM2\_DETAIL\_DATA**  
    
  Business Transaction Monitoring performance data at agent level will be deleted after this period.  
    
  Unit: Minutes  
    
  Default value: 10080 (10080 minutes = 168 hours = seven days = one week)

- **KEEP\_PERIOD\_AGGREGATE\_DATA**  
    
  Other performance data aggregated at agent group level will be deleted after this period.  
    
  Unit: Hours  
    
  Default value: 1488 (1488 hours = 62 days = two 31-day months)

- **KEEP\_PERIOD\_DETAIL\_DATA**  
    
  Agent resource data will be deleted after this period.  
    
  Unit: Minutes  
    
  Default value: 10080 (10080 minutes = 168 hours = seven days = one week)

- **KEEP\_PERIOD\_PROCESS\_DATA**  
    
  Agent process data will be deleted after this period.  
    
  Unit: Minutes  
    
  Default value: 10080 (10080 minutes = 168 hours = seven days = one week)

- **KEEP\_PERIOD\_TRAFFIC\_DETAIL\_DATA**  
    
  Detailed data (AGENT\_TRAFFIC\_DETAIL) will be deleted after this period.  
    
  Unit: Minutes  
    
  Default value: 10080 (10080 minutes = 168 hours = seven days = one week)

- **KEEP\_PERIOD\_UNMONITORED\_DATA**  
    
  Aggregated data about unmonitored servers will be deleted after this period.  
    
  Unit: Hours  
    
  Default value: 48 (48 hours = two days)

# **Frontend Databases**

Data retention periods (also known askeep periods) on frontend databases are also controlled by the agent configuration settings **(ADMINISTRATION > Agent Configuration > Configurations > \[Edit\] > Advanced).**

![](/attachments/performanceguard/7ac724f3-3e74-40e8-960b-fc5fed13b928.png)  
See also [Agent Configuration Group Settings](/performanceguard/administration/manage-agent-configuration-groups/agent-configuration-group-settings/) > Advanced.