This chapter explains how maintenance activities can affect the performance of other Adaptive Server activities, and how to improve the performance of maintenance tasks.
Maintenance activities include tasks such as dropping and recreating indexes, performing dbcc checks, and updating table and index statistics. All of these activities can compete with other processing work on the server.
Whenever possible, perform maintenance tasks when your Adaptive Server usage is low. This chapter can help you determine the impact these activities have on individual applicaton performance, and on overall Adaptive Server performance.
