Over-Aggressive Scheduled Maintenance Jobs
Over-Aggressive Backup Schedules
To avoid an over aggressive backup strategy TIBCO recommends the following strategy:
These backup strategies not only cause performance issues but also cause high CPU and input/output utilization. TIBCO recommends changing the scheduled maintenance activities to no incremental backups and full backup once a week.
There were improvements in the CPU and input/output utilization which in turn improved performance at the customer location.
Over-Aggressive T-Logs Backup
To avoid overhead, TIBCO recommends configuring the T-Log backup schedule to run every four hours rather than every 15 minutes.
Over-Aggressive Reorganization and Rebuild of Indexes
To avoid overhead, set the schedule for the reorganization and rebuild of indexes to a weekly basis rather than every day.
Additional places to look at for performance issues include reviewing your network or the overall hardware configuration of the database server.
The information in this chapter is based on a recent experience at a customer site and this effort is an ongoing activity.