WUtils.com

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)

NameOriginCIMType
ActivememorygrantamountKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
ActivememorygrantscountWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
AvgDiskReadIOmsWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
AvgDiskWriteIOmsWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CachememorytargetKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CompilememorytargetKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CPUcontroleffectPercentWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CPUusagePercentWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CPUusagetargetPercentWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
DiskReadBytesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskReadIOPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskReadIOThrottledPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskWriteBytesPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskWriteIOPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskWriteIOThrottledPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
MaxmemoryKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
MemorygrantsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
MemorygranttimeoutsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
PendingmemorygrantscountWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
QueryexecmemorytargetKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
TargetmemoryKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
UsedmemoryKBWin32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats properties

Local properties (22) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats class

…
▲ ActivememorygrantamountKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'ActivememorygrantamountKB'
CounterType65792
Description'Total amount of granted memory in kilobytes in the resource pool.'
DisplayName'Active memory grant amount (KB)'
DisplayName009'Active memory grant amount (KB)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ActivememorygrantamountKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Activememorygrantscount property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Activememorygrantscount'
CounterType65792
Description'Number of query memory grants in the resource pool.'
DisplayName'Active memory grants count'
DisplayName009'Active memory grants count'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Activememorygrantscount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgDiskReadIOms property
CIMTYPE'uint64'
CookingType'PERF_AVERAGE_BULK'
Counter'AvgDiskReadIOms'
CounterType1073874176
Description'Average time, in milliseconds, of a read operation from the disk'
DisplayName'Avg Disk Read IO (ms)'
DisplayName009'Avg Disk Read IO (ms)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
AvgDiskReadIOms property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgDiskWriteIOms property
CIMTYPE'uint64'
CookingType'PERF_AVERAGE_BULK'
Counter'AvgDiskWriteIOms'
CounterType1073874176
Description'Average time, in milliseconds, of a write operation to the disk'
DisplayName'Avg Disk Write IO (ms)'
DisplayName009'Avg Disk Write IO (ms)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
AvgDiskWriteIOms property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ CachememorytargetKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'CachememorytargetKB'
CounterType65792
Description'Current memory target for cache memory in kilobytes.'
DisplayName'Cache memory target (KB)'
DisplayName009'Cache memory target (KB)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CachememorytargetKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CompilememorytargetKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'CompilememorytargetKB'
CounterType65792
Description'Current memory target for query compile in kilobytes.'
DisplayName'Compile memory target (KB)'
DisplayName009'Compile memory target (KB)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CompilememorytargetKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CPUcontroleffectPercent property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'CPUcontroleffectPercent'
CounterType65792
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 %'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CPUcontroleffectPercent 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
…
▲ CPUusagetargetPercent property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'CPUusagetargetPercent'
CounterType65792
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 %'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
CPUusagetargetPercent property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskReadBytesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'DiskReadBytesPersec'
CounterType65792
Description'Number of bytes read from the disk in the last second'
DisplayName'Disk Read Bytes/sec'
DisplayName009'Disk Read Bytes/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DiskReadBytesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskReadIOPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'DiskReadIOPersec'
CounterType65792
Description'Number of read operations from the disk in the last second'
DisplayName'Disk Read IO/sec'
DisplayName009'Disk Read IO/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DiskReadIOPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskReadIOThrottledPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'DiskReadIOThrottledPersec'
CounterType65792
Description'Number of read operations throttled in the last second'
DisplayName'Disk Read IO Throttled/sec'
DisplayName009'Disk Read IO Throttled/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DiskReadIOThrottledPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskWriteBytesPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'DiskWriteBytesPersec'
CounterType65792
Description'Number of bytes written to the disk in the last second'
DisplayName'Disk Write Bytes/sec'
DisplayName009'Disk Write Bytes/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DiskWriteBytesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskWriteIOPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'DiskWriteIOPersec'
CounterType65792
Description'Number of write operations to the disk in the last second'
DisplayName'Disk Write IO/sec'
DisplayName009'Disk Write IO/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DiskWriteIOPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskWriteIOThrottledPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'DiskWriteIOThrottledPersec'
CounterType65792
Description'Number of write operations throttled in the last second'
DisplayName'Disk Write IO Throttled/sec'
DisplayName009'Disk Write IO Throttled/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
DiskWriteIOThrottledPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ MaxmemoryKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'MaxmemoryKB'
CounterType65792
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)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
MaxmemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MemorygrantsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'MemorygrantsPersec'
CounterType272696576
Description'Number of query memory grants per second occurring in the resource pool.'
DisplayName'Memory grants/sec'
DisplayName009'Memory grants/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
MemorygrantsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MemorygranttimeoutsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'MemorygranttimeoutsPersec'
CounterType272696576
Description'Number of query memory grant timeouts per second occurring in the resource pool.'
DisplayName'Memory grant timeouts/sec'
DisplayName009'Memory grant timeouts/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
MemorygranttimeoutsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Pendingmemorygrantscount property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Pendingmemorygrantscount'
CounterType65792
Description'Number of queries waiting for memory grants in the resource pool.'
DisplayName'Pending memory grants count'
DisplayName009'Pending memory grants count'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Pendingmemorygrantscount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ QueryexecmemorytargetKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'QueryexecmemorytargetKB'
CounterType65792
Description'Current memory target for query execution memory grant in kilobytes.'
DisplayName'Query exec memory target (KB)'
DisplayName009'Query exec memory target (KB)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
QueryexecmemorytargetKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TargetmemoryKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'TargetmemoryKB'
CounterType65792
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)'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
TargetmemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ UsedmemoryKB property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'UsedmemoryKB'
CounterType65792
Description'Used amount of memory in kilobytes in the resource pool.'
DisplayName'Used memory (KB)'
DisplayName009'Used memory (KB)'
HelpIndex0
PerfIndex0
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

…
▲ 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_SQLServerResourcePoolStats Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1✓✗✓✗✓
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats'✓✗✓✗✓
CookedTrue✓✗✓✗✓
Description'Statistics associated with resource pools'✓✗✓✓✓
DisplayName'SQLServer:Resource Pool Stats'✓✗✓✓✓
DisplayName009'SQLServer:Resource Pool Stats'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerResourcePoolStats

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