Optimizing database performance

Automatic maintenance

To maintain fast response times for Alvao applications, the database performance optimization is automatically performed every Sunday between 3:00 am and 3:55 am.

note

Automatic maintenance will only start if more than 5 days have passed since the last optimization.

Manual maintenance

If you need to perform performance optimization immediately, use the Administration - Database maintenance - Optimize performance.

tip

If you upgrade SQL Server to a higher version or move the database to another SQL Server with a higher version, also increase the compatibility level of the database to the highest available. This will improve the performance of the database.