App Control Server performs its own database maintenance.

The following sections describe two maintenance tasks and their schedule:

DailyPruneTask

This task runs every midnight (App Control Server local time). It performs the following actions in sequence:

  1. Cleans up obsolete inventory records. This includes records of old files deleted from endpoints as well as inventory files related to deleted computers,
  2. Cleans up events and notifications that are below the configured retention threshold,
  3. Collects server performance statistics,
  4. (Optionally – if configured) Deletes old file catalog files that have 0 prevalence on agent machines,
  5. Performs various other data maintenance and cleanup tasks.

DailyPruneTask usually takes between 30 minutes and 3 hours, depending on database size and churn. Console performance might be slower while this task is running.

Database Maintenance

This task runs every Saturday, at 3 AM. It performs the following actions:

  1. Defragments database indexes that have a high level of fragmentation (>20%).
  2. Creates missing database statistics.
  3. Updates obsolete database statistics.

Depending on database size, Database Maintenance can run from 1 to 6 hours. Console performance and other operations might be impacted while this task is running.