versaSRS Knowledge Base
versaSRS - Database Maintenance Plans
FAQ - Knowledge Base
The information in this article applies to:
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.
3. Rebuild Index
Did the information in this article help answer your question?
Did not apply
Print this page
Send to a friend
Add to Favorites
VersaDev Support Services