SAP ABAP Message Class SMMSS_ALERTS Message Number 018 (This alert shows if the memory setting for SQL Server follows SAP rec.)

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

Attribute

Message class	SMMSS_ALERTS
Short Description	Message class for MSSQL rz20 messages
Message Number	018
Documentation status		Space: object requires documentation
Authorization check Error Message	☐
Changed On	20130531

Message Text

This alert shows if the memory setting for SQL Server follows SAP rec.

Help Document

Diagnosis

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

Procedure

Procedure for System Administration

History

Last changed on/by	20130531	SAP
SAP Release Created in