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.
|