Database maintenance

Manual maintenance

It is convenient to run the statistics updates and index defragmentation on the SQL server to maintain quick response of ALVAO applications. Use the Admin – File – Database maintenance – Optimize performance command to do that.

Automatic maintenance

We recommend to create a scheduled task which will be run for example once a month on the SQL Server. It is time-consuming and loads the database, so we do NOT recommend to execute it in system operating hours. If you are using the SQL Server Workgroup edition or later, you can use for example the following procedure for setting up the scheduled task:

1. Open Microsoft SQL Management Studio and connect to the SQL Server where the ALVAO database is located.
2. In the Object Explorer select Management – Maintenance Plans and then select Maintenance Plan Wizard from the context menu.
3. A wizard is launched, and you first enter the following:
   1. Name – name of the task,
   2. Description – its description, and
   3. Schedule – planning – set for example to Sunday midnight with monthly or weekly run.
4. In the next dialog select the tasks you require to run – Rebuild Index and Update statistics.
5. In the next dialog set the order of running, so the statistics update has been executed earlier.
6. Setting the statistics update is next. Here select the following:
   1. ALVAO database,
   2. Tables and views object,
   3. All existing statistics, and
   4. Full scan.
7. For index defragmentation select the following:
   1. ALVAO database,
   2. Tables and views object, and
   3. Default free space per page.
8. You can generate also the report during the task and send it to a specific e-mail.
9. In the last dialog there is the settings summary which you check and then finish the settings.

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