WUtils.com

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats, ROOT\CIMV2

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

Description

Statistics associated with resource pools

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats properties

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats has 24 properties (15 Local, 9 Derived)

NameOriginCIMType
ActivememorygrantamountKBWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
ActivememorygrantscountWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
CachememorytargetKBWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
CompilememorytargetKBWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
CPUcontroleffectPercentWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
CPUusagePercentWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
CPUusagePercent_BaseWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
CPUusagetargetPercentWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
MaxmemoryKBWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
MemorygrantsPersecWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
MemorygranttimeoutsPersecWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
PendingmemorygrantscountWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
QueryexecmemorytargetKBWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
TargetmemoryKBWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
UsedmemoryKBWin32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats properties

Local properties (15) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats 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
…
▲ 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
…
▲ 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_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats 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_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Statistics associated with resource pools'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'MSSQL$MICROSOFT##WID:Resource Pool Stats'✓✗✓✓✓
DisplayName009'MSSQL$MICROSOFT##WID:Resource Pool Stats'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQL$MICROSOFT##WID'✓✗✓✗✓

Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats System properties

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

Similar Classes to Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDResourcePoolStats

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