Clean up Performance Analytics data collections

Performance Analytics scores and snapshots may grow over time. Use a scheduled job to clean up the tables.

Before you begin

Role required: admin

About this task

The Clean PA collections scheduled job is active by default. The table cleaner deletes records according to best practices, so there is no impact on performance. By default, the job runs daily so it only has to delete a relatively small amount of data.

You can view and modify this scheduled job.

Procedure

  1. Navigate to System Scheduler > Scheduled Jobs > Scheduled Jobs.
  2. Click Clean PA collections to see its contents.
  3. Make any necessary changes. For example, change the run time when the job needs to be executed.
  4. Click Update to save your changes.

Result

These system properties determine how long data is kept.
Table 1. System properties used to clean up Performance Analytics collections
Property Default Value
Maximum number of days the scores will be kept before being deleted (com.snc.pa.dc.keep_scores_for) 1826 (5 years)
Maximum number of days the lists of records related to a score will be kept before being deleted (com.snc.pa.dc.keep_snapshots_for) 365