- Active Connections
- Active Sorts
- Application In Lock Wait (%)
- Applications in Lock Wait
- Average Direct Read Time (ms)
- Average Direct Write Time (ms)
- Average Lock Wait Time (s)
- Average Locks Held Per App
- Average Physical Read Time (ms)
- Average Physical Write Time (ms)
- Average Pool I/O Time (ms)
- Average Pool Read Time (ms)
- Average Pool Write Time (ms)
- Average Sort Time (ms)
- Average Synchronous I/O (ms)
- Average Synchronous Read (ms)
- Average Synchronous Write (ms)
- Buffer Pool Hit Ratio (%)
- Buffer Pool Hit Ratio, Index (%)
- Buffer Pool I/Os per Second
- Catalog Cache Hit Ratio (%)
- Cleaners due to Dirty Threshold
- Commits Attempted
- Committed Statements per Second
- Current Connections
- Current Gateway Connections
- DDL SQL Statements
- DDL SQL (%)
- Deadlock Rollbacks (%)
- Deadlocks
- Dynamic SQL Statements
- Failed SQL Statements
- Failed SQL (%)
- Failed SQL (%)
- Gateway Connections Waiting for Client
Request
- Gateway Connections Waiting for Host
Reply
- Lock Escalations
- Lock List In Use (bytes)
- Lock Timeouts
- Lock Waits
- Locks Held
- Page Cleans
- Pages for each Cleaner
- Pages for each Prefetch Request
- Prefetch Requests
- Rollbacks Attempted
- Rollbacks Attempted
- Rollbacks per Second
- Rollbacks per Second
- Select SQL Statements
- Select SQL (%)
- Sort Overflowed (%)
- SQL Statements
- SQL Statements per Second
- SQL Statements per Second
- Static SQL Statements
- Synchronous Read Time (ms)
- Synchronous Reads (4K pages)
- Synchronous Write Time (ms)
- Synchronous Writes (4K pages)
- Total Attempted Gateway Connections
- Total Connections
- Total Deadlocks
- Total Direct I/O Time (ms)
- Total Exclusive Lock Escalations
- Total Lock Wait Time (ms)
- Total Log Space Cleaners Invoked
- Total Pool Physical I/O (ms)
- Total Pool Physical Read (ms)
- Total Pool Physical Write (ms)
- Total Pool Reads (4K pages)
- Total Pool Writes (4K pages)
- Total Prefetch Request (4K
page)
- Total Sort Heap In Use (4K page)
- Total Sort Time (ms)
- Total Synchronous I/O Time (ms)
- Total Synchronous I/O (4K pages)
- Transactions
- Transactions per Second
- UID SQL (%)
- Update/Insert/Delete SQL
- Victim Page Cleaners Invoked