Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

SQL Server, Workload Group Stats Object

The SQLServer:Workload Group Stats object contains performance counters that report information about Resource Governor workload group statistics.

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

Counter name

Description

Queued requests

The current number of queued requests that is waiting to be picked up. This count can be non-zero if throttling occurs after the GROUP_MAX_REQUESTS limit is reached.

Active requests

The number of requests that are currently running in this workload group. This should be equivalent to the count of rows from sys.dm_exec_requests filtered by group ID.

Requests completed/sec

The number of requests that have completed in this workload group. This number is cumulative.

CPU usage %

The CPU bandwidth usage by all requests in this workload group measured relative to the computer and normalized to all the 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.

Max request CPU time (ms)

The maximum CPU time, in milliseconds, used by a request currently running in the workload group.

Blocked requests

The current number of blocked requests in the workload group. This can be used to determine workload characteristics.

Reduced memory grants/sec

The number of queries that are getting less than ideal amount of memory grants per second.

Max request memory grant (KB)

The maximum value of memory grant, in kilobytes (KB), for a query.

Query optimizations/sec

The number of query optimizations that have happened in this workload group per second. This can be used to determine workload characteristics.

Suboptimal plans/sec

The number of suboptimal plans that are generated in this workload group per second.

Active parallel threads

The current count of parallel threads usage.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.