System Maintenance
This article explains how the system resources are maintained in Agility.
Key Information
- 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.
- 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).
- 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.
- We recommend that you back up any localization files you've created for quicker system recovery.
Related concepts
Related tasks
Installing and Configuring Analytics to use an Existing SQL Server User