Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats, ROOT\CIMV2

Class | Methods | Properties (21) | Qualifiers (12) | Instances (1) | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Description

Statistics associated with workload groups

Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats properties

Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats has 21 properties (12 Local, 9 Derived)

NameOriginCIMType
ActiveparallelthreadsWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
ActiverequestsWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
BlockedtasksWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CPUusagePercentWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
CPUusagePercent_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
MaxrequestcputimemsWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
MaxrequestmemorygrantKBWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
QueryoptimizationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
QueuedrequestsWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
ReducedmemorygrantsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
RequestscompletedPersecWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
SuboptimalplansPersecWin32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats properties

Local properties (12) of Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats class

Activeparallelthreads property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of threads used by parallel queries in the workload group. Serial queries and the main thread of parallel queries are not included in this number.'
DetailLevel100
DisplayName'Active parallel threads'
DisplayName009'Active parallel threads'
HelpIndex0
PerfIndex0
Activeparallelthreads property is in 4 classes of ROOT\cimv2 and in 1 namespace
Activerequests property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of currently running requests in the workload group.'
DetailLevel100
DisplayName'Active requests'
DisplayName009'Active requests'
HelpIndex0
PerfIndex0
Activerequests property is in 8 classes of ROOT\cimv2 and in 1 namespace
Blockedtasks property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of blocked tasks in the workload group.'
DetailLevel100
DisplayName'Blocked tasks'
DisplayName009'Blocked tasks'
HelpIndex0
PerfIndex0
Blockedtasks property is in 4 classes of ROOT\cimv2 and in 1 namespace
CPUusagePercent property
CIMTYPE'uint64'
CounterType537003264
DefaultScale0
Description'System CPU usage by all requests in the specified instance of the performance object.'
DetailLevel100
DisplayName'CPU usage %'
DisplayName009'CPU usage %'
HelpIndex0
PerfDefaultTrue
PerfIndex0
CPUusagePercent property is in 8 classes of ROOT\cimv2 and in 1 namespace
CPUusagePercent_Base property
CIMTYPE'uint64'
CounterType1073939712
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
CPUusagePercent_Base property is in 4 classes of ROOT\cimv2 and in 1 namespace
Maxrequestcputimems property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'Maximum CPU time in milliseconds used by a request in the workload group.'
DetailLevel100
DisplayName'Max request cpu time (ms)'
DisplayName009'Max request cpu time (ms)'
HelpIndex0
PerfIndex0
Maxrequestcputimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
MaxrequestmemorygrantKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Maximum value of memory grant in kilobytes used by a query in the workload group.'
DetailLevel100
DisplayName'Max request memory grant (KB)'
DisplayName009'Max request memory grant (KB)'
HelpIndex0
PerfIndex0
MaxrequestmemorygrantKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
QueryoptimizationsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of query optimizations per second occurring in the workload group.'
DetailLevel100
DisplayName'Query optimizations/sec'
DisplayName009'Query optimizations/sec'
HelpIndex0
PerfIndex0
QueryoptimizationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
Queuedrequests property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of requests waiting in the queue due to resource governor limits in the workload group.'
DetailLevel100
DisplayName'Queued requests'
DisplayName009'Queued requests'
HelpIndex0
PerfIndex0
Queuedrequests property is in 4 classes of ROOT\cimv2 and in 1 namespace
ReducedmemorygrantsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of queries per second getting less than ideal amount of memory in the workload group.'
DetailLevel100
DisplayName'Reduced memory grants/sec'
DisplayName009'Reduced memory grants/sec'
HelpIndex0
PerfIndex0
ReducedmemorygrantsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
RequestscompletedPersec property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'Number of completed requests per second in the workload group.'
DetailLevel100
DisplayName'Requests completed/sec'
DisplayName009'Requests completed/sec'
HelpIndex0
PerfIndex0
RequestscompletedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
SuboptimalplansPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of suboptimal query plans generated per second in the workload group.'
DetailLevel100
DisplayName'Suboptimal plans/sec'
DisplayName009'Suboptimal plans/sec'
HelpIndex0
PerfIndex0
SuboptimalplansPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats class

Caption property
CIMTYPE'string'
Description'A short textual description (one-line string) for the statistic or metric.'
MaxLen64
readTrue
Caption property is in 1050 classes of ROOT\cimv2 and in 37 namespaces
Description property
CIMTYPE'string'
Description'A textual description of the statistic or metric.'
readTrue
Description property is in 1061 classes of ROOT\cimv2 and in 142 namespaces
Frequency_Object property
CIMTYPE'uint64'
Frequency_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Frequency_PerfTime property
CIMTYPE'uint64'
Frequency_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Frequency_Sys100NS property
CIMTYPE'uint64'
Frequency_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Name property
CIMTYPE'string'
Description'The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property. '
keyTrue
MaxLen256
readTrue
Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
Timestamp_Object property
CIMTYPE'uint64'
Timestamp_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Timestamp_PerfTime property
CIMTYPE'uint64'
Timestamp_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces
Timestamp_Sys100NS property
CIMTYPE'uint64'
Timestamp_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Statistics associated with workload groups'
DetailLevel100
DisplayName'SQLServer:Workload Group Stats'
DisplayName009'SQLServer:Workload Group Stats'
dynamicTrue
GenericPerfCtrTrue
HelpIndex0
HiPerfTrue
Locale1033
PerfIndex0
provider'WmiPerfInst'
RegistryKey'MSSQLSERVER'

Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats'___SYSTEM8
__NAMESPACE'ROOT\cimv2'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8
__PROPERTY_COUNT21___SYSTEM3
__RELPATH'Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats'___SYSTEM8
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8
__SUPERCLASS'Win32_PerfRawData'___SYSTEM8
__CLASS'Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats

Number of classes:1
Class nameChildsPropertiesMethodsClass
Instances
Child
Instances
AbstractSingleton
Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats02001---
comments powered by Disqus
WUtils.com