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 )
Detailed description of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats properties Local properties (11) of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats class ▲ Activeparallelthreads propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Activeparallelthreads' CounterType 65792 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' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Activeparallelthreads property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Activerequests propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Activerequests' CounterType 65792 Description 'Number of currently running requests in the workload group.' DisplayName 'Active requests' DisplayName009 'Active requests' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Activerequests property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ Blockedtasks propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Blockedtasks' CounterType 65792 Description 'Number of blocked tasks in the workload group.' DisplayName 'Blocked tasks' DisplayName009 'Blocked tasks' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Blockedtasks property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ CPUusagePercent propertyCIMTYPE 'uint64' CookingType '' Counter 'CPUusagePercent' CounterType 537003264 Description 'System CPU usage by all requests in the specified instance of the performance object.' DisplayName 'CPU usage %' DisplayName009 'CPU usage %' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' CPUusagePercent property is in 8 classes of ROOT\cimv2 and in 1 namespace
▲ Maxrequestcputimems propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Maxrequestcputimems' CounterType 65792 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)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Maxrequestcputimems property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ MaxrequestmemorygrantKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'MaxrequestmemorygrantKB' CounterType 65792 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)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' MaxrequestmemorygrantKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ QueryoptimizationsPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'QueryoptimizationsPersec' CounterType 272696576 Description 'Number of query optimizations per second occurring in the workload group.' DisplayName 'Query optimizations/sec' DisplayName009 'Query optimizations/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' QueryoptimizationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Queuedrequests propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Queuedrequests' CounterType 65792 Description 'Number of requests waiting in the queue due to resource governor limits in the workload group.' DisplayName 'Queued requests' DisplayName009 'Queued requests' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Queuedrequests property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ ReducedmemorygrantsPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'ReducedmemorygrantsPersec' CounterType 272696576 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' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' ReducedmemorygrantsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ RequestscompletedPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'RequestscompletedPersec' CounterType 65792 Description 'Number of completed requests per second in the workload group.' DisplayName 'Requests completed/sec' DisplayName009 'Requests completed/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' RequestscompletedPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ SuboptimalplansPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'SuboptimalplansPersec' CounterType 272696576 Description 'Number of suboptimal query plans generated per second in the workload group.' DisplayName 'Suboptimal plans/sec' DisplayName009 'Suboptimal plans/sec' HelpIndex 0 PerfIndex 0 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
▲ Name propertyCIMTYPE '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. ' key True MaxLen 256 read True Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local
AutoCook 1 ✓ ✗ ✓ ✗ ✓
AutoCook_RawClass 'Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats' ✓ ✗ ✓ ✗ ✓
Cooked True ✓ ✗ ✓ ✗ ✓
Description 'Statistics associated with workload groups' ✓ ✗ ✓ ✓ ✓
DisplayName 'MSSQL$MICROSOFT##WID:Workload Group Stats' ✓ ✗ ✓ ✓ ✓
DisplayName009 'MSSQL$MICROSOFT##WID:Workload Group Stats' ✓ ✗ ✓ ✗ ✓
dynamic True ✓ ✗ ✓ ✗ ✓
GenericPerfCtr True ✓ ✗ ✓ ✗ ✓
HelpIndex 0 ✓ ✗ ✓ ✗ ✓
HiPerf True ✓ ✗ ✓ ✗ ✓
Locale 1033 ✓ ✗ ✓ ✓ ✓
PerfIndex 0 ✓ ✗ ✓ ✗ ✓
provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓
RegistryKey 'MSSQL$MICROSOFT##WID' ✓ ✗ ✓ ✗ ✓
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats System properties Similar Classes to Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDWorkloadGroupStats Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by