How To Fix SMMSS_ALERTS018 - This alert shows if the memory setting for SQL Server follows SAP rec.

SMMSS_ALERTS018 - Overview

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message SMMSS_ALERTS018 - This alert shows if the memory setting for SQL Server follows SAP rec. ?

  The SAP error message SMMSS_ALERTS018 indicates that the memory settings for SQL Server do not align with the recommendations provided by SAP. This alert is part of the monitoring and alerting framework in SAP systems that utilize Microsoft SQL Server as the database.
  
  Cause:
  The primary cause of this alert is that the SQL Server memory configuration is not optimized according to SAP's best practices. This can lead to performance issues, as SQL Server may not have enough memory allocated to handle the workload efficiently, or it may be over-allocated, causing resource contention with other applications.
  
  Solution:
  To resolve this issue, you should adjust the memory settings for SQL Server to align with SAP's recommendations. Here are the steps you can take:
  
  
  Check Current Memory Settings:
  
  Open SQL Server Management Studio (SSMS).
  Connect to your SQL Server instance.
  Right-click on the server name and select "Properties."
  Go to the "Memory" section to view the current settings for "Minimum server