Setting Up a Database Maintenance Schedule

Database maintenance clears out received events over 90 days old, reorganizes indexes that are more than 5 percent fragmented, and (on the SQL Server Enterprise Edition) rebuilds indexes that are more than 30 percent fragmented. It is enabled by default and occurs automatically at 2 AM daily, according to the Time Zone setting for your installation.

IMPORTANT: Running database maintenance daily is highly recommended to improve performance for large organizations with high levels of database usage.

Consider the database maintenance time carefully when updating the Imprivata PatientSecure database.

Follow best practices in maintaining, backing up, and recovering your database server.

You can disable database maintenance or change the time of day when it runs.

  1. In the Admin Console, go to Settings > General.

  2. In the Database Maintenance Enabled field, select ON to enable or OFF to disable.

  3. In the Database Maintenance Time field, enter a time in the format provided or click and select a new time setting (in the server's local time) when database maintenance will run.

  4. Click Save.

If you are using SQL Server Standard Edition, scheduled database maintenance will not rebuild indexes automatically. In this case, set up a SQL Server job to rebuild indexes on a regular basis.

NOTE: Because SQL Server Standard Edition does not support the online option when rebuilding indexes, there may be a performance lag during the rebuild process. For more information, see "Perform Index Operations Online" on the Microsoft Developer Network website.