Databases are changing constantly to stay current with business needs. This may result in degradation of performance unless maintenance is performed.. Periodic maintenance is required for any size of database. The following basic steps are included in a maintenance plan to extend the life of databases and to get the best performance from databases:

• Daily backup of Databases (Incremental or Full Backup).
• Update Statistics (Once a day).
• Re-organization of Indexes (Daily is ideal, but weekly is must).
• Periodic user maintenance (Adding and Removing Users).
• Periodic archival of historical data.
• Data cleansing to improve the data quality.
• Tuning existing user defined queries.
• Regular checking of concurrency and resolving it on-demand.
• Monitoring current growth and estimating the future growth of data.

A & S Database Consulting Inc. guides and encourages enterprises to have scheduled maintenance of databases and performance optimization of persistent data.