WUtils.com

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