SAP ABAP Data Element MSQMEMSET (Specifies how SQL Server memory parameters have been set)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-MSS (Application Component) Microsoft SQL Server
     STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Data Element MSQMEMSET
Short Description Specifies how SQL Server memory parameters have been set  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type CHAR010    
Data Type CHAR   Character String 
Length 10    
Decimal Places 0    
Output Length 10    
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 MemSetting 
Medium 15 Memory setting 
Long 20 Memory setting 
Heading 14 Memory setting 
Documentation

Definition

If the SQL Server parameter min server memory has been set to 0, then this field is set to AUTO, meaning SQL Server will automatically use the memory it requires. If min server memory is set equal to max server memory, then this field is set to FIXED, meaning SQL Server will use exactly the memory specified by these 2 parameters. The other value is RANGE, which means SQL Server will use memory in a range between these 2 parameter settings.

History
Last changed by/on SAP  20110908 
SAP Release Created in