SQL Server, Resource Pool Stats Object

 

Applies To: SQL Server 2016

The SQLServer:Resource Pool Stats object contains performance counters that report information about Resource Governor resource pool statistics.

Each active resource pool creates an instance of the SQLServer:Resource Pool Stats performance object that has the same instance name as the Resource Governor resource pool name. The following table describes counters supported on this instance.

Counter nameDescription
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 countCurrent 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) BaseFor internal use only.
Avg Disk Write IO (ms)Average time, in milliseconds, of a write operation to the disk.
Avg Disk Write IO (ms) BaseFor 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 % baseFor 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 % baseFor 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 SQL Server process changes. It is not normalized to what the SQL Server process receives.
CPU usage % baseFor 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/secNumber of bytes read from the disk in the last second.
Disk Read IO Throttled/secNumber of read operations throttled in the last second.
Disk Read IO/secNumber of read operations from the disk in the last second.
Disk Write Bytes/secNumber of bytes written to the disk in the last second.
Disk Write IO Throttled/secNumber of write operations throttled in the last second.
Disk Write IO/secNumber 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/secThe number of memory grant time-outs per second.
Memory grants/secThe number of memory grants occurring in this resource pool per second.
Pending memory grant countThe 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.

Monitor Resource Usage (System Monitor)
SQL Server, Workload Group Stats Object
Resource Governor

Community Additions

ADD
Show: