This alert shows if the memory setting for SQL Server follows SAP rec.
Message type: E = Error
Message class: SMMSS_ALERTS - Message class for MSSQL rz20 messages
Message number: 018
Message text: This alert shows if the memory setting for SQL Server follows SAP rec.
What causes this issue?
This alert shows is the memory settings for SQL Server, defined as
either FIXED, RANGE or AUTO, follow SAP recommendations. SAP
recommends that memory be FIXED, max server memory = min server
memory, for systems where SQL Server runs with an SAP instance. AUTO,
where max server memory is large and min server memory = 0, is
recommended for stand alone database servers. RANGE is recommended in
certain cases where update work processes are present on the database
server. These settings are just guidelines, hence only a yellow
condition if they aren't followed.
System Response
The system issues an error message and will not allow you to continue with this transaction until the error is resolved.
How to fix this error?
Procedure for System Administrators
Error message extract from SAP system. Copyright SAP SE.
Related Error Messages
SMMSS_ALERTS017 This alert shows which trace flags were used to start SQL Server
SMMSS_ALERTS016 This alert shows a configuration required in SQL Server has not been done
SMMSS_ALERTS019 SQL Server self monitoring
SMMSS_ALERTS020 This alert show information about the Operating System