| Active memory grant amount (KB) |
The current total amount, in kilobytes (KB), of granted memory. This information is also available in sys.dm_exec_query_resource_semaphores. |
| Active memory grants count |
Current total count of memory grants. This information is also available in sys.dm_exec_query_memory_grants. |
| Avg Disk Read IO (ms) |
Average time, in milliseconds, of a read operation from the disk. |
| Avg Disk Read IO (ms) Base |
For internal use only. |
| Avg Disk Write IO (ms) |
Average time, in milliseconds, of a write operation to the disk. |
| Avg Disk Write IO (ms) Base |
For internal use only. |
| Cache memory target (KB) |
The current memory broker target, in kilobytes (KB), for cache. |
| Compile memory target (KB) |
The current memory broker target, in kilobytes (KB), for query compiles. |
| CPU control effect % |
The effect of Resource Governor on the resource pool. Calculated as (CPU usage %) / (CPU usage % without Resource Governor. |
| CPU delayed % |
System CPU delayed for all requests in the specified instance of the performance object as a percentage of the total time active. |
| CPU delayed % base |
For internal use only. |
| CPU effective % |
System CPU usage by all requests in the specified instance of the performance object as a percentage of the total time active. |
| CPU effective % base |
For internal use only. |
| CPU usage % |
The CPU bandwidth usage by all requests in all workload groups belonging to this pool. This is measured relative to the computer and normalized to all CPUs on the system. This value will change as the amount of CPU available to the [!INCLUDEssNoVersion] process changes. It is not normalized to what the [!INCLUDEssNoVersion] process receives. |
| CPU usage % base |
For internal use only. |
| CPU usage target % |
The target value of CPU usage % for the resource pool based on the resource pool configuration settings and system load. |
| CPU violated % |
The difference between the CPU reservation and the effective scheduling percentage. |
| Disk Read Bytes/sec |
Number of bytes read from the disk in the last second. |
| Disk Read IO Throttled/sec |
Number of read operations throttled in the last second. |
| Disk Read IO/sec |
Number of read operations from the disk in the last second. |
| Disk Write Bytes/sec |
Number of bytes written to the disk in the last second. |
| Disk Write IO Throttled/sec |
Number of write operations throttled in the last second. |
| Disk Write IO/sec |
Number of write operations to the disk in the last second. |
| Max memory (KB) |
The maximum amount, in kilobytes (KB), of memory that the resource pool can have based on the resource pool settings and server state. |
| Memory grant timeouts/sec |
The number of memory grant time-outs per second. |
| Memory grants/sec |
The number of memory grants occurring in this resource pool per second. |
| Pending memory grant count |
The number of requests for memory grants pending in the queues. This information is also available in sys.dm_exec_query_resource_semaphores. |
| Query exec memory target (KB) |
The current memory broker target, in kilobytes (KB), for query execution memory grant. This information is also available in sys.dm_exec_query_memory_grants. |
| Target memory (KB) |
The target amount, in kilobytes (KB), of memory the resource pool is trying to obtain based on the resource pool settings and server state. |
| Used memory (KB) |
The amount of memory used, in kilobytes (KB), for the resource pool. |