Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats, ROOT\CIMV2

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

Description

Statistics associated with workload groups

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats properties

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats has 20 properties (11 Local, 9 Derived)

NameOriginCIMType
ActiveparallelthreadsWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
ActiverequestsWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
BlockedtasksWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CPUusagePercentWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
MaxrequestcputimemsWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
MaxrequestmemorygrantKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
QueryoptimizationsPersecWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
QueuedrequestsWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
ReducedmemorygrantsPersecWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
RequestscompletedPersecWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
SuboptimalplansPersecWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats properties

Local properties (11) of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats 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_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats 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_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1
AutoCook_RawClass'Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats'
CookedTrue
Description'Statistics associated with workload groups'
DisplayName'MSSQL$MICROSOFT##WID:Workload Group Stats'
DisplayName009'MSSQL$MICROSOFT##WID:Workload Group Stats'
dynamicTrue
GenericPerfCtrTrue
HelpIndex0
HiPerfTrue
Locale1033
PerfIndex0
provider'WmiPerfInst'
RegistryKey'MSSQL$MICROSOFT##WID'

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats

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