SAP ABAP Data Element MSQCFMINSM (Controls the minimum amount of memory allocated to SQL Servr)
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
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 | MSQCFMINSM |
| Short Description | Controls the minimum amount of memory allocated to SQL Servr |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | INT4 | |
| Data Type | INT4 | 4-byte integer, integer number with sign |
| 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 | SQLMINMEM |
| Medium | 0 | |
| Long | 0 | |
| Heading | 0 |
Documentation
Definition
Use this field to control the minimum amount of memory SQL Server can use. On installations were SQL Server runs on a dedicated computer, the SQL Server default, 0, can be used. On computers running SQL Server and various SAP work processes, this value should be 45 % of the available memory on the computer, and equal to the maximum amount of memory allocated to SQL Server. On computers running SQL Server and only UPDATE SAP work processes, this value should be 40 %.
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
