Database Configuration

The following elements provide information particularly helpful for database configuration.

• Buffer Pool Data Logical Reads
• Buffer Pool Data Physical Reads
• Buffer Pool Data Writes
• Buffer Pool Index Logical Reads
• Buffer Pool Index Physical Reads
• Buffer Pool Index Writes
• Total Buffer Pool Physical Read Time
• Total Buffer Pool Physical Write Time
• Database Files Closed
• Buffer Pool Asynchronous Data Reads
• Buffer Pool Asynchronous Data Writes
• Buffer Pool Asynchronous Index Writes
• Buffer Pool Asynchronous Index Reads
• Buffer Pool Asynchronous Read Time
• Buffer Pool Asynchronous Write Time
• Buffer Pool Asynchronous Read Requests
• Buffer Pool Log Space Cleaners Triggered
• Buffer Pool Victim Page Cleaners Triggered
• Buffer Pool Threshold Cleaners Triggered
• Buffer Pool Information
• Time Waited for Prefetch
• Buffer Pool Data Pages to Extended Storage
• Buffer Pool Index Pages to Extended Storage
• Buffer Pool Data Pages from Extended Storage
• Buffer Pool Index Pages from Extended Storage
• Direct Reads From Database
• Direct Writes to Database
• Direct Read Requests
• Direct Write Requests
• Direct Read Time
• Direct Write Time
• Catalog Cache Lookups
• Catalog Cache Inserts
• Catalog Cache Overflows
• Catalog Cache Heap Full
• Package Cache Lookups
• Package Cache Inserts
• Package Cache Overflows
• Maximum Package Cache Size
• Section Lookups
• Section Inserts
• Maximum Database Heap Allocated
• Maximum Secondary Log Space Used
• Maximum Total Log Space Used
• Secondary Logs Allocated Currently
• Number of Log Pages Read
• Number of Log Pages Written
• Unit of Work Log Space Used