WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats, ROOT\CIMV2

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

Description

Statistics associated with resource pools

Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats properties

Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats has 34 properties (25 Local, 9 Derived)

NameOriginCIMType
ActivememorygrantamountKBWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
ActivememorygrantscountWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
AvgDiskReadIOmsWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
AvgDiskReadIOms_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats19 [uint32]
AvgDiskWriteIOmsWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
AvgDiskWriteIOms_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats19 [uint32]
CachememorytargetKBWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CompilememorytargetKBWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CPUcontroleffectPercentWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CPUusagePercentWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CPUusagePercent_BaseWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
CPUusagetargetPercentWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
DiskReadBytesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskReadIOPersecWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskReadIOThrottledPersecWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskWriteBytesPersecWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskWriteIOPersecWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
DiskWriteIOThrottledPersecWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
MaxmemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
MemorygrantsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
MemorygranttimeoutsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
PendingmemorygrantscountWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
QueryexecmemorytargetKBWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
TargetmemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
UsedmemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats properties

Local properties (25) of Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats class

…
▲ ActivememorygrantamountKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Total amount of granted memory in kilobytes in the resource pool.'
DetailLevel100
DisplayName'Active memory grant amount (KB)'
DisplayName009'Active memory grant amount (KB)'
HelpIndex0
PerfIndex0
ActivememorygrantamountKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Activememorygrantscount property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of query memory grants in the resource pool.'
DetailLevel100
DisplayName'Active memory grants count'
DisplayName009'Active memory grants count'
HelpIndex0
PerfIndex0
Activememorygrantscount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgDiskReadIOms property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time, in milliseconds, of a read operation from the disk'
DetailLevel100
DisplayName'Avg Disk Read IO (ms)'
DisplayName009'Avg Disk Read IO (ms)'
HelpIndex0
PerfIndex0
AvgDiskReadIOms property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgDiskReadIOms_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgDiskReadIOms_Base property is in 1 class (Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats) of ROOT\cimv2 and in 1 namespace
…
▲ AvgDiskWriteIOms property
CIMTYPE'uint64'
CounterType1073874176
DefaultScale0
Description'Average time, in milliseconds, of a write operation to the disk'
DetailLevel100
DisplayName'Avg Disk Write IO (ms)'
DisplayName009'Avg Disk Write IO (ms)'
HelpIndex0
PerfIndex0
AvgDiskWriteIOms property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ AvgDiskWriteIOms_Base property
CIMTYPE'uint32'
CounterType1073939458
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
AvgDiskWriteIOms_Base property is in 1 class (Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats) of ROOT\cimv2 and in 1 namespace
…
▲ CachememorytargetKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Current memory target for cache memory in kilobytes.'
DetailLevel100
DisplayName'Cache memory target (KB)'
DisplayName009'Cache memory target (KB)'
HelpIndex0
PerfIndex0
CachememorytargetKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CompilememorytargetKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Current memory target for query compile in kilobytes.'
DetailLevel100
DisplayName'Compile memory target (KB)'
DisplayName009'Compile memory target (KB)'
HelpIndex0
PerfIndex0
CompilememorytargetKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CPUcontroleffectPercent property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Effect of the resource governor on the resource pool calculated as (CPU usage %) / (CPU usage % without RG).'
DetailLevel100
DisplayName'CPU control effect %'
DisplayName009'CPU control effect %'
HelpIndex0
PerfIndex0
CPUcontroleffectPercent property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CPUusagePercent property
CIMTYPE'uint64'
CounterType537003264
DefaultScale0
Description'System CPU usage by all requests in the specified instance of the performance object.'
DetailLevel100
DisplayName'CPU usage %'
DisplayName009'CPU usage %'
HelpIndex0
PerfDefaultTrue
PerfIndex0
CPUusagePercent property is in 8 classes of ROOT\cimv2 and in 1 namespace
…
▲ CPUusagePercent_Base property
CIMTYPE'uint64'
CounterType1073939712
DefaultScale0
Description''
DetailLevel100
DisplayName''
DisplayName009''
HelpIndex0
PerfIndex0
CPUusagePercent_Base property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ CPUusagetargetPercent property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Target value of 'CPU usage %' for the resource pool based on the configuration settings and the system load.'
DetailLevel100
DisplayName'CPU usage target %'
DisplayName009'CPU usage target %'
HelpIndex0
PerfIndex0
CPUusagetargetPercent property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskReadBytesPersec property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of bytes read from the disk in the last second'
DetailLevel100
DisplayName'Disk Read Bytes/sec'
DisplayName009'Disk Read Bytes/sec'
HelpIndex0
PerfIndex0
DiskReadBytesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskReadIOPersec property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of read operations from the disk in the last second'
DetailLevel100
DisplayName'Disk Read IO/sec'
DisplayName009'Disk Read IO/sec'
HelpIndex0
PerfIndex0
DiskReadIOPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskReadIOThrottledPersec property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of read operations throttled in the last second'
DetailLevel100
DisplayName'Disk Read IO Throttled/sec'
DisplayName009'Disk Read IO Throttled/sec'
HelpIndex0
PerfIndex0
DiskReadIOThrottledPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskWriteBytesPersec property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of bytes written to the disk in the last second'
DetailLevel100
DisplayName'Disk Write Bytes/sec'
DisplayName009'Disk Write Bytes/sec'
HelpIndex0
PerfIndex0
DiskWriteBytesPersec property is in 6 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskWriteIOPersec property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of write operations to the disk in the last second'
DetailLevel100
DisplayName'Disk Write IO/sec'
DisplayName009'Disk Write IO/sec'
HelpIndex0
PerfIndex0
DiskWriteIOPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ DiskWriteIOThrottledPersec property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of write operations throttled in the last second'
DetailLevel100
DisplayName'Disk Write IO Throttled/sec'
DisplayName009'Disk Write IO Throttled/sec'
HelpIndex0
PerfIndex0
DiskWriteIOThrottledPersec property is in 2 classes of ROOT\cimv2 and in 1 namespace
…
▲ MaxmemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Maximum amount of memory in kilobytes the resource pool can have based on the settings and server state.'
DetailLevel100
DisplayName'Max memory (KB)'
DisplayName009'Max memory (KB)'
HelpIndex0
PerfIndex0
MaxmemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MemorygrantsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of query memory grants per second occurring in the resource pool.'
DetailLevel100
DisplayName'Memory grants/sec'
DisplayName009'Memory grants/sec'
HelpIndex0
PerfIndex0
MemorygrantsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MemorygranttimeoutsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of query memory grant timeouts per second occurring in the resource pool.'
DetailLevel100
DisplayName'Memory grant timeouts/sec'
DisplayName009'Memory grant timeouts/sec'
HelpIndex0
PerfIndex0
MemorygranttimeoutsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Pendingmemorygrantscount property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of queries waiting for memory grants in the resource pool.'
DetailLevel100
DisplayName'Pending memory grants count'
DisplayName009'Pending memory grants count'
HelpIndex0
PerfIndex0
Pendingmemorygrantscount property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ QueryexecmemorytargetKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Current memory target for query execution memory grant in kilobytes.'
DetailLevel100
DisplayName'Query exec memory target (KB)'
DisplayName009'Query exec memory target (KB)'
HelpIndex0
PerfIndex0
QueryexecmemorytargetKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TargetmemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Target amount of memory in kilobytes the resource pool is trying to attain based on the settings and server state.'
DetailLevel100
DisplayName'Target memory (KB)'
DisplayName009'Target memory (KB)'
HelpIndex0
PerfIndex0
TargetmemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ UsedmemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Used amount of memory in kilobytes in the resource pool.'
DetailLevel100
DisplayName'Used memory (KB)'
DisplayName009'Used memory (KB)'
HelpIndex0
PerfIndex0
UsedmemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_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_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats Qualifiers

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

Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerResourcePoolStats

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