Monitoring and Tuning Database Performance › Items to Monitor and Tune

Items to Monitor and Tune

Monitoring the Database

For your database, the major areas of degradation are:

• Pages over 70% full
• CALC and VIA (clustered) record overflow
• Fragmented records
• Inefficient index structures
• An increase in logically-deleted or relocated records