WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager, ROOT\CIMV2

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

Description

This defines memory usage.

Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager properties

Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager has 29 properties (20 Local, 9 Derived)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
ConnectionMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
DatabaseCacheMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
ExternalbenefitofmemoryWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
FreeMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
GrantedWorkspaceMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
LockBlocksWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
LockBlocksAllocatedWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
LockMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
LockOwnerBlocksWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
LockOwnerBlocksAllocatedWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
LogPoolMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
MaximumWorkspaceMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
MemoryGrantsOutstandingWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
MemoryGrantsPendingWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
NameCIM_StatisticalInformation8 [string]
OptimizerMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
ReservedServerMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
SQLCacheMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
StolenServerMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
TargetServerMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TotalServerMemoryKBWin32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager properties

Local properties (20) of Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager class

…
▲ ConnectionMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Total amount of dynamic memory the server is using for maintaining connections'
DetailLevel100
DisplayName'Connection Memory (KB)'
DisplayName009'Connection Memory (KB)'
HelpIndex0
PerfIndex0
ConnectionMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DatabaseCacheMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Amount of memory the server is currently using for the database cache.'
DetailLevel100
DisplayName'Database Cache Memory (KB)'
DisplayName009'Database Cache Memory (KB)'
HelpIndex0
PerfIndex0
DatabaseCacheMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Externalbenefitofmemory property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'The external value of memory, in ms per page per ms, multiplied by 10 billion and truncated to an integer'
DetailLevel100
DisplayName'External benefit of memory'
DisplayName009'External benefit of memory'
HelpIndex0
PerfDefaultTrue
PerfIndex0
Externalbenefitofmemory property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FreeMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Amount of memory the server is currently not using.'
DetailLevel100
DisplayName'Free Memory (KB)'
DisplayName009'Free Memory (KB)'
HelpIndex0
PerfIndex0
FreeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ GrantedWorkspaceMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations.'
DetailLevel100
DisplayName'Granted Workspace Memory (KB)'
DisplayName009'Granted Workspace Memory (KB)'
HelpIndex0
PerfIndex0
GrantedWorkspaceMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LockBlocks property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'The current number of lock blocks that are in use on the server. Refreshed periodically.'
DetailLevel100
DisplayName'Lock Blocks'
DisplayName009'Lock Blocks'
HelpIndex0
PerfIndex0
LockBlocks property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LockBlocksAllocated property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'The current number of allocated lock blocks.'
DetailLevel100
DisplayName'Lock Blocks Allocated'
DisplayName009'Lock Blocks Allocated'
HelpIndex0
PerfIndex0
LockBlocksAllocated property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LockMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Total amount of dynamic memory the server is using for locks'
DetailLevel100
DisplayName'Lock Memory (KB)'
DisplayName009'Lock Memory (KB)'
HelpIndex0
PerfIndex0
LockMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LockOwnerBlocks property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'The number of lock owner blocks that are currently in use on the server. Refreshed periodically.'
DetailLevel100
DisplayName'Lock Owner Blocks'
DisplayName009'Lock Owner Blocks'
HelpIndex0
PerfIndex0
LockOwnerBlocks property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LockOwnerBlocksAllocated property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'The current number of allocated lock owner blocks.'
DetailLevel100
DisplayName'Lock Owner Blocks Allocated'
DisplayName009'Lock Owner Blocks Allocated'
HelpIndex0
PerfIndex0
LockOwnerBlocksAllocated property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogPoolMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Total amount of dynamic memory the server is using for Log Pool'
DetailLevel100
DisplayName'Log Pool Memory (KB)'
DisplayName009'Log Pool Memory (KB)'
HelpIndex0
PerfIndex0
LogPoolMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MaximumWorkspaceMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Total amount of memory available for grants to executing processes. This memory is used primarily for hash, sort and create index operations.'
DetailLevel100
DisplayName'Maximum Workspace Memory (KB)'
DisplayName009'Maximum Workspace Memory (KB)'
HelpIndex0
PerfIndex0
MaximumWorkspaceMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MemoryGrantsOutstanding property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Current number of processes that have successfully acquired a workspace memory grant'
DetailLevel100
DisplayName'Memory Grants Outstanding'
DisplayName009'Memory Grants Outstanding'
HelpIndex0
PerfIndex0
MemoryGrantsOutstanding property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MemoryGrantsPending property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Current number of processes waiting for a workspace memory grant'
DetailLevel100
DisplayName'Memory Grants Pending'
DisplayName009'Memory Grants Pending'
HelpIndex0
PerfIndex0
MemoryGrantsPending property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ OptimizerMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Total amount of dynamic memory the server is using for query optimization'
DetailLevel100
DisplayName'Optimizer Memory (KB)'
DisplayName009'Optimizer Memory (KB)'
HelpIndex0
PerfIndex0
OptimizerMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ReservedServerMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-2
Description'Amount of memory the server has reserved for future usage. This counter shows current unused amount of the initial grant shown in Granted Workspace Memory (KB).'
DetailLevel100
DisplayName'Reserved Server Memory (KB)'
DisplayName009'Reserved Server Memory (KB)'
HelpIndex0
PerfIndex0
ReservedServerMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SQLCacheMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Total amount of dynamic memory the server is using for the dynamic SQL cache'
DetailLevel100
DisplayName'SQL Cache Memory (KB)'
DisplayName009'SQL Cache Memory (KB)'
HelpIndex0
PerfIndex0
SQLCacheMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ StolenServerMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Amount of memory the server is currently using for the purposes other than the database pages.'
DetailLevel100
DisplayName'Stolen Server Memory (KB)'
DisplayName009'Stolen Server Memory (KB)'
HelpIndex0
PerfIndex0
StolenServerMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TargetServerMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Ideal amount of memory the server is willing to consume'
DetailLevel100
DisplayName'Target Server Memory (KB)'
DisplayName009'Target Server Memory (KB)'
HelpIndex0
PerfIndex0
TargetServerMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TotalServerMemoryKB property
CIMTYPE'uint64'
CounterType65792
DefaultScale-4
Description'Total amount of dynamic memory the server is currently consuming'
DetailLevel100
DisplayName'Total Server Memory (KB)'
DisplayName009'Total Server Memory (KB)'
HelpIndex0
PerfIndex0
TotalServerMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager 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. '
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_SQLServerMemoryManager Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'This defines memory usage.'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:Memory Manager'✓✗✓✓✓
DisplayName009'SQLServer:Memory Manager'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓
SingletonTrue✓✓✗✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager

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