versaSRS Knowledge Base

 

 


versaSRS - Database Maintenance Plans

Article ID: Q731239

Category: FAQ - Knowledge Base

The information in this article applies to:

  • versaSRS

Database growth impacting on versaSRS performance.

Database performance is slow within versaSRS.



Both a Weekly and a Daily Database Maintenance Plan should be created and scheduled to run accordingly.


The Weekly Database Maintenance Plan as outlined below should be run initially.



VersaDev recommends the following Daily Database Maintenance plan be set up in relation to versaSRS.


These recommended tasks should be added as per the order below. VersaDev are not responsible to set up Maintenance plans.

1. Check database integrity.

2. Check database size - in this step the business needs to decide whether to define an alert to ensure that the database never reaches capacity and fails. As a recommendation the DBA should set a warning of at least 15% to ensure that the additional space is made available.

3. Reorganise Index

4. Update Statistics

5. Clean-up History

6. Backup Database

7. Maintenance Clean-up


VersaDev recommends the following Weekly Database Maintenance plan be set up in relation to versaSRS.


These recommended tasks should be added as per the order below. VersaDev are not responsible to set up Maintenance plans.

1. Check database integrity.

2. Check database size - in this step the business needs to decide whether to define an alert to ensure that the database never reaches capacity and fails. As a recommendation the DBA should set a warning of at least 15% to ensure that the additional space is made available.

3. Rebuild Index

4. Update Statistics

5. Clean-up History

6. Backup Database

7. Maintenance Clean-up











Did the information in this article help answer your question?

Yes
No
Did not apply


Last Reviewed: 03/04/2015
Powered by VersaDev Copyright 1999 - 2014
Last Reviewed 03/04/2015

Print this page  Print this page
Click link to send to a friend  Send to a friend
Add to Favorites  Add to Favorites

Provided by
VersaDev Support Services