App Control Database: SQL Maintenance

App Control Server does its own scheduled SQL DB Maintenance tasks on daily and weekly basis. This functionality is important in order to maintain database performance and limit growth. The maintenance tasks include:

• Deleting obsolete data
• Defragmenting indexes
• Rebuilding statistics

Note: Use of any other, custom maintenance tasks would be counter-productive and should be avoided.