Skip to main content
Version: 25.0

System Maintenance

This article explains how the system resources are maintained in Agility.

Key Information

  1. Microsoft SQL Server should be set to Update Statistics automatically (the default setting). This improves ongoing performance of the system as the database grows over time.
  2. To keep reporting data current, schedule the DatamartLoader to run on a recurring basis. More details or guidance is provided in the 'Load the Datamart' topic in V1Datamart.pdf (packaged with the setup executables).
  3. Regular full database backups of Digital.ai Agility and Analytics databases should be performed. This activity can be scheduled using Microsoft SQL Server Management Studio. A full database backup is required to restore the system should a hardware failure occur. It is not necessary to back up the Datamart database, as it can be recreated using the Digital.ai Agility DatamartLoader.
  4. We recommend that you back up any localization files you've created for quicker system recovery.

Data Mart and ETL

Installing and Configuring Analytics to use an Existing SQL Server User