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.