System and Database Maintenance

This section reviews all your alternatives for performing standard system and database maintenance and walks you through manually planning for and performing the required tasks, including:

Database Tasks
Creating a list of daily and weekly activities to consider
Clearing Temp tables in the Security (EvolutionConfig) database
Re-indexing the eSite database (NOTE: this applies to all modules, eSite, eFinancials, eService and eDex)
Performing database consistency checks
Reviewing the Event Log for errors
Database backups
System Tasks
Clearing old records from the Letters or Output directory
Deleting Temp tables within the eSite database

Terminology

A Database Maintenance Plan is a specific SQL Server option within Enterprise Manager. A SQL Server Maintenance Plan cannot clear Temp tables or delete old letter/output files.

Develop a Plan

AMSI strongly recommends setting up and implementing some sort of regular maintenance plan in order to maximize the efficiency and performance of the AMSI Evolution Suite. A well planned and executed maintenance plan lets you regularly and consistently take care of basic housekeeping tasks such as:

Clearing temp tables
Deleting old letters or output files
Re-indexing databases
Performing backups

Note

If using the SQL Database Maintenance Wizard, you cannot clear Temp tables or delete old letters or output files. These must be taken care of manually or by using the eSite Tuneup Utility.