Hierarchy
⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Data Element | MSSMEMSTATEDESC |
Short Description | Memory state description |
Data Type
Category of Dictionary Type | Direct Type Entry | |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | ||
Data Type | CHAR | Character String |
Length | 16 | |
Decimal Places | 0 | |
Output Length | 16 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 10 | desc |
Medium | 15 | Description |
Long | 24 | Memory state description |
Heading | 50 | Memory state description from sys.dm_os_sys_memory |
Documentation
Definition
Description of the memory state.
ConditionValue
system_high_memory_signal_state = 1 and
system_low_memory_signal_state = 0 Available physical memory is high
system_high_memory_signal_state = 0 and
system_low_memory_signal_state = 1 Available physical memory is low
system_high_memory_signal_state = 0 and
system_low_memory_signal_state = 0 Physical memory usage is steady
system_high_memory_signal_state = 1 and
system_low_memory_signal_state = 1 Physical memory state is transitioning.
The high and low signal should never be on at the same time. However, rapid changes at the operating system level can cause both values to appear to be on to a user mode application. The appearance of both signals being on will be interpreted as a transition state.
History
Last changed by/on | SAP | 20140117 |
SAP Release Created in | 740 |