| Avail IO |
Server |
Shows the current number of available I/O control blocks. |
| Connection Count |
Database |
Shows the number of connections to this database. |
| Main Heap Bytes |
Server |
Shows the number of bytes used for global database server data structures. |
| Query: Plan cache pages |
Connection and database |
Shows the number of pages used to cache execution plans. |
| Query: Low memory strategies |
Connection and database |
Shows the number of times the database server changed its execution plan during execution because of low memory conditions. |
| Query: Rows materialized/sec |
Connection and database |
Shows the rate at which rows are written to work tables during query processing. |
| Requests: GET DATA/sec |
Connection and database |
Shows the rate at which a connection is issuing GET DATA requests. |
| Temporary Table Pages |
Connection and database |
Shows the number of pages in the temporary file used for temporary tables. |
| Version Store Pages |
Database |
Shows the number of pages of the temporary file currently being used for the row version store when snapshot isolation is
enabled.
|