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---
WUtils.com
online utility - toplist