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.

Did not find what you were looking for? Ask our technical support team.