Export (0) Print
Expand All

SQL Server, Resource Pool Stats Object

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 name

Description

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 target %

The target value of CPU usage % for the resource pool based on the resource pool configuration settings and system load.

CPU control effect %

The effect of Resource Governor on the resource pool. Calculated as (CPU usage %) / (CPU usage % without Resource Governor.

Compile memory target (KB)

The current memory broker target, in kilobytes (KB), for query compiles.

Cache memory target (KB)

The current memory broker target, in kilobytes (KB), for cache.

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.

Memory grants/sec

The number of memory grants occurring in this resource pool per second.

Active memory grants count

Current total count of memory grants. This information is also available in sys.dm_exec_query_memory_grants.

Memory grant timeouts/sec

The number of memory grant time-outs per second.

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.

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.

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.

Used memory (KB)

The amount of memory used, in kilobytes (KB), for the resource pool.

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.

Community Additions

ADD
Show:
© 2014 Microsoft