Database Maintenance

Index Maintenance

Maintenance for the database is considered index maintenance for the purpose of this document. Standard database maintenance based on the best practices of the customer’s organization are also recommended. If no standard practice exists, the following is the recommended approach. Ola Hallengren’s maintenance scripts are the recommended scripts to setup a standard maintenance plan.

• Daily:
  • Update statistics 1 to 2 times a day at non-peak hours.
  • Re-organize indexes on “B_MASTER_REPOSITORY_ITEM” and all tables that being with “B_SNAPSHOT” that have more than 10% fragmentation.
  • Following the re-organizations, it is recommended that the integrity of the database is checked.
• Weekly:
  • Rebuild indexes for any tables with fragmentation over 30%. Additionally, “B_MASTER_REPOSITORY_ITEM” and all tables that begin with “B_SNAPSHOT” should be specifically targeted.