Maintenance

This dialog allows the user to gauge performance of the database and run regular database maintenance. All of the maintenance options mentioned here can be scheduled to run automatically if you are using Microsoft SQL Server or SQL Express. Contact your administrator for more information on scheduling this required maintenance.

Server Name

The name of the machine where SQL Server is running.

Server Maintenance

Select one or more options from the list and click Process to perform the selected maintenance routine(s).

Reindex Database

This process rebuilds and defragments the indices on the database. This should be used if the database is performing slowly after multiple edits. Reindexing the database has no effect on your data. It requires exclusive access to the database, which means that no one can have Time open when you run this command.

Benchmark

The benchmark option will run a test to gauge the performance of your database. You can use this to determine if you should run maintenance routines. You will see output in messages window such as "Benchmark Time: 0.0631 sec". A lower benchmark time means you database is performing more quickly.

Update Statistics

The Update Statistics option rebuild statistics on the database, which allow the server to fetch your data more quickly. This option has a large impact on the performance of the database. It should be run every day or after a large amount of data is changed. Updating statistics will have no effect on your data.

Check Integrity

This option is available for Microsoft SQL Server. It will check the database files to make sure that they have not become corrupt in any way. It requires exclusive access to the database, which means that no one can have Time open when you run this command. While it is executing, your Time file will be closed. When it is complete, you file will be opened again. Any corrupt data found will be repair by the server.