Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats, ROOT\CIMV2
Class
| Methods | Properties (31)
| Qualifiers (14)
| Instances (1)
| Namespaces (1)
Samples: VB Script
| C#
| VB.Net
| Search on:Microsoft
Description Statistics associated with resource pools
Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats properties Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats has 31 properties (22 Local , 9 Derived )
Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats properties Local properties (22) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats class ▲ ActivememorygrantamountKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'ActivememorygrantamountKB' CounterType 65792 Description 'Total amount of granted memory in kilobytes in the resource pool.' DisplayName 'Active memory grant amount (KB)' DisplayName009 'Active memory grant amount (KB)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' ActivememorygrantamountKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Activememorygrantscount propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Activememorygrantscount' CounterType 65792 Description 'Number of query memory grants in the resource pool.' DisplayName 'Active memory grants count' DisplayName009 'Active memory grants count' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Activememorygrantscount property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ AvgDiskReadIOms propertyCIMTYPE 'uint64' CookingType 'PERF_AVERAGE_BULK' Counter 'AvgDiskReadIOms' CounterType 1073874176 Description 'Average time, in milliseconds, of a read operation from the disk' DisplayName 'Avg Disk Read IO (ms)' DisplayName009 'Avg Disk Read IO (ms)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' AvgDiskReadIOms property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ AvgDiskWriteIOms propertyCIMTYPE 'uint64' CookingType 'PERF_AVERAGE_BULK' Counter 'AvgDiskWriteIOms' CounterType 1073874176 Description 'Average time, in milliseconds, of a write operation to the disk' DisplayName 'Avg Disk Write IO (ms)' DisplayName009 'Avg Disk Write IO (ms)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' AvgDiskWriteIOms property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ CachememorytargetKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'CachememorytargetKB' CounterType 65792 Description 'Current memory target for cache memory in kilobytes.' DisplayName 'Cache memory target (KB)' DisplayName009 'Cache memory target (KB)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' CachememorytargetKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ CompilememorytargetKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'CompilememorytargetKB' CounterType 65792 Description 'Current memory target for query compile in kilobytes.' DisplayName 'Compile memory target (KB)' DisplayName009 'Compile memory target (KB)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' CompilememorytargetKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ CPUcontroleffectPercent propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'CPUcontroleffectPercent' CounterType 65792 Description 'Effect of the resource governor on the resource pool calculated as (CPU usage %) / (CPU usage % without RG).' DisplayName 'CPU control effect %' DisplayName009 'CPU control effect %' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' CPUcontroleffectPercent 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
▲ CPUusagetargetPercent propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'CPUusagetargetPercent' CounterType 65792 Description 'Target value of 'CPU usage %' for the resource pool based on the configuration settings and the system load.' DisplayName 'CPU usage target %' DisplayName009 'CPU usage target %' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' CPUusagetargetPercent property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ DiskReadBytesPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'DiskReadBytesPersec' CounterType 65792 Description 'Number of bytes read from the disk in the last second' DisplayName 'Disk Read Bytes/sec' DisplayName009 'Disk Read Bytes/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' DiskReadBytesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
▲ DiskReadIOPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'DiskReadIOPersec' CounterType 65792 Description 'Number of read operations from the disk in the last second' DisplayName 'Disk Read IO/sec' DisplayName009 'Disk Read IO/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' DiskReadIOPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ DiskReadIOThrottledPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'DiskReadIOThrottledPersec' CounterType 65792 Description 'Number of read operations throttled in the last second' DisplayName 'Disk Read IO Throttled/sec' DisplayName009 'Disk Read IO Throttled/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' DiskReadIOThrottledPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ DiskWriteBytesPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'DiskWriteBytesPersec' CounterType 65792 Description 'Number of bytes written to the disk in the last second' DisplayName 'Disk Write Bytes/sec' DisplayName009 'Disk Write Bytes/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' DiskWriteBytesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
▲ DiskWriteIOPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'DiskWriteIOPersec' CounterType 65792 Description 'Number of write operations to the disk in the last second' DisplayName 'Disk Write IO/sec' DisplayName009 'Disk Write IO/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' DiskWriteIOPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ DiskWriteIOThrottledPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'DiskWriteIOThrottledPersec' CounterType 65792 Description 'Number of write operations throttled in the last second' DisplayName 'Disk Write IO Throttled/sec' DisplayName009 'Disk Write IO Throttled/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' DiskWriteIOThrottledPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ MaxmemoryKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'MaxmemoryKB' CounterType 65792 Description 'Maximum amount of memory in kilobytes the resource pool can have based on the settings and server state.' DisplayName 'Max memory (KB)' DisplayName009 'Max memory (KB)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' MaxmemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ MemorygrantsPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'MemorygrantsPersec' CounterType 272696576 Description 'Number of query memory grants per second occurring in the resource pool.' DisplayName 'Memory grants/sec' DisplayName009 'Memory grants/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' MemorygrantsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ MemorygranttimeoutsPersec propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_BULK_COUNT' Counter 'MemorygranttimeoutsPersec' CounterType 272696576 Description 'Number of query memory grant timeouts per second occurring in the resource pool.' DisplayName 'Memory grant timeouts/sec' DisplayName009 'Memory grant timeouts/sec' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' MemorygranttimeoutsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Pendingmemorygrantscount propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Pendingmemorygrantscount' CounterType 65792 Description 'Number of queries waiting for memory grants in the resource pool.' DisplayName 'Pending memory grants count' DisplayName009 'Pending memory grants count' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Pendingmemorygrantscount property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ QueryexecmemorytargetKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'QueryexecmemorytargetKB' CounterType 65792 Description 'Current memory target for query execution memory grant in kilobytes.' DisplayName 'Query exec memory target (KB)' DisplayName009 'Query exec memory target (KB)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' QueryexecmemorytargetKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ TargetmemoryKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'TargetmemoryKB' CounterType 65792 Description 'Target amount of memory in kilobytes the resource pool is trying to attain based on the settings and server state.' DisplayName 'Target memory (KB)' DisplayName009 'Target memory (KB)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' TargetmemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ UsedmemoryKB propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'UsedmemoryKB' CounterType 65792 Description 'Used amount of memory in kilobytes in the resource pool.' DisplayName 'Used memory (KB)' DisplayName009 'Used memory (KB)' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' UsedmemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats 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_MSSQLSERVER_SQLServerResourcePoolStats Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local
AutoCook 1 ✓ ✗ ✓ ✗ ✓
AutoCook_RawClass 'Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats' ✓ ✗ ✓ ✗ ✓
Cooked True ✓ ✗ ✓ ✗ ✓
Description 'Statistics associated with resource pools' ✓ ✗ ✓ ✓ ✓
DisplayName 'SQLServer:Resource Pool Stats' ✓ ✗ ✓ ✓ ✓
DisplayName009 'SQLServer:Resource Pool Stats' ✓ ✗ ✓ ✗ ✓
dynamic True ✓ ✗ ✓ ✗ ✓
GenericPerfCtr True ✓ ✗ ✓ ✗ ✓
HelpIndex 0 ✓ ✗ ✓ ✗ ✓
HiPerf True ✓ ✗ ✓ ✗ ✓
Locale 1033 ✓ ✗ ✓ ✓ ✓
PerfIndex 0 ✓ ✗ ✓ ✗ ✓
provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓
RegistryKey 'MSSQLSERVER' ✓ ✗ ✓ ✗ ✓
Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats System properties Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.