WUtils.com

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager, ROOT\CIMV2

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

Description

This defines memory usage.

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager properties

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager has 29 properties (20 Local, 9 Derived)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
ConnectionMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
DatabaseCacheMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
ExternalbenefitofmemoryWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
FreeMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
GrantedWorkspaceMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
LockBlocksWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
LockBlocksAllocatedWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
LockMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
LockOwnerBlocksWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
LockOwnerBlocksAllocatedWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
LogPoolMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
MaximumWorkspaceMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
MemoryGrantsOutstandingWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
MemoryGrantsPendingWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
NameCIM_StatisticalInformation8 [string]
OptimizerMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
ReservedServerMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
SQLCacheMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
StolenServerMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
TargetServerMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TotalServerMemoryKBWin32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager properties

Local properties (20) of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager class

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

Derived properties (9) of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager 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_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1✓✗✓✗✓
AutoCook_RawClass'Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager'✓✗✓✗✓
CookedTrue✓✗✓✗✓
Description'This defines memory usage.'✓✗✓✓✓
DisplayName'MSSQL$MICROSOFT##WID:Memory Manager'✓✗✓✓✓
DisplayName009'MSSQL$MICROSOFT##WID:Memory Manager'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQL$MICROSOFT##WID'✓✗✓✗✓
SingletonTrue✓✓✗✗✓

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDMemoryManager

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