WUtils.com

Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats, ROOT\CIMV2

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

Description

Statistics associated with workload groups

Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats has 20 properties (11 Local, 9 Derived)

NameOriginCIMType
ActiveparallelthreadsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
ActiverequestsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
BlockedtasksWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CPUusagePercentWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
MaxrequestcputimemsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
MaxrequestmemorygrantKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
QueryoptimizationsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
QueuedrequestsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
ReducedmemorygrantsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
RequestscompletedPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
SuboptimalplansPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats properties

Local properties (11) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats class

…
▲ Activeparallelthreads property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Activeparallelthreads'
CounterType65792
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.'
DisplayName'Active parallel threads'
DisplayName009'Active parallel threads'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Activeparallelthreads property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Activerequests property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Activerequests'
CounterType65792
Description'Number of currently running requests in the workload group.'
DisplayName'Active requests'
DisplayName009'Active requests'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Activerequests property is in 8 classes of ROOT\cimv2 and in 1 namespace
…
▲ Blockedtasks property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Blockedtasks'
CounterType65792
Description'Number of blocked tasks in the workload group.'
DisplayName'Blocked tasks'
DisplayName009'Blocked tasks'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Blockedtasks property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CPUusagePercent property
CIMTYPE'uint64'
CookingType''
Counter'CPUusagePercent'
CounterType537003264
Description'System CPU usage by all requests in the specified instance of the performance object.'
DisplayName'CPU usage %'
DisplayName009'CPU usage %'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CPUusagePercent property is in 8 classes of ROOT\cimv2 and in 1 namespace
…
▲ Maxrequestcputimems property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Maxrequestcputimems'
CounterType65792
Description'Maximum CPU time in milliseconds used by a request in the workload group.'
DisplayName'Max request cpu time (ms)'
DisplayName009'Max request cpu time (ms)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Maxrequestcputimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MaxrequestmemorygrantKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'MaxrequestmemorygrantKB'
CounterType65792
Description'Maximum value of memory grant in kilobytes used by a query in the workload group.'
DisplayName'Max request memory grant (KB)'
DisplayName009'Max request memory grant (KB)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
MaxrequestmemorygrantKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ QueryoptimizationsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'QueryoptimizationsPersec'
CounterType272696576
Description'Number of query optimizations per second occurring in the workload group.'
DisplayName'Query optimizations/sec'
DisplayName009'Query optimizations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
QueryoptimizationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Queuedrequests property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Queuedrequests'
CounterType65792
Description'Number of requests waiting in the queue due to resource governor limits in the workload group.'
DisplayName'Queued requests'
DisplayName009'Queued requests'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Queuedrequests property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ReducedmemorygrantsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ReducedmemorygrantsPersec'
CounterType272696576
Description'Number of queries per second getting less than ideal amount of memory in the workload group.'
DisplayName'Reduced memory grants/sec'
DisplayName009'Reduced memory grants/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ReducedmemorygrantsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ RequestscompletedPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'RequestscompletedPersec'
CounterType65792
Description'Number of completed requests per second in the workload group.'
DisplayName'Requests completed/sec'
DisplayName009'Requests completed/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RequestscompletedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SuboptimalplansPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'SuboptimalplansPersec'
CounterType272696576
Description'Number of suboptimal query plans generated per second in the workload group.'
DisplayName'Suboptimal plans/sec'
DisplayName009'Suboptimal plans/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
SuboptimalplansPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_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_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1✓✗✓✗✓
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerWorkloadGroupStats'✓✗✓✗✓
CookedTrue✓✗✓✗✓
Description'Statistics associated with workload groups'✓✗✓✓✓
DisplayName'SQLServer:Workload Group Stats'✓✗✓✓✓
DisplayName009'SQLServer:Workload Group Stats'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats System properties

…
NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats'___SYSTEM8✗✗
__NAMESPACE'ROOT\cimv2'___SYSTEM8✗✗
__SERVER'.'___SYSTEM8✗✗
__DERIVATION['Win32_PerfFormattedData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8✗✓
__PROPERTY_COUNT20___SYSTEM3✗✗
__RELPATH'Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats'___SYSTEM8✗✗
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8✗✗
__SUPERCLASS'Win32_PerfFormattedData'___SYSTEM8✗✗
__CLASS'Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats'___SYSTEM8✗✗
__GENUS1___SYSTEM3✗✗

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerWorkloadGroupStats

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