How To Fix SQLM024 - SQL Monitor is currently switched OFF by system profile parameter &1

SQLM024 - Overview

• Message type: E = Error

• Message class: SQLM - SQL Monitor messages to the world

• Message number: 024

• Message text: SQL Monitor is currently switched OFF by system profile parameter &1

What causes this issue?

The SQL Monitor emergency main switch has been switched off by profile
parameter "&V1&". Consequently, the SQL Monitor is not collecting any
data.
Please contact your system administrator in order to set the profile
parameter "&V1&" to ?on? using transaction ?RZ11?.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

SQLM024 - Details

• The SAP error message SQLM024 indicates that the SQL Monitor is currently switched off due to a system profile parameter setting. This typically means that the SQL Monitor functionality, which is used for monitoring and analyzing SQL statements in the SAP system, is not enabled.
  
  Cause:
  The SQL Monitor is controlled by a system profile parameter, specifically sql/monitor/enable. If this parameter is set to 0, the SQL Monitor is disabled, leading to the error message SQLM024 when you attempt to use SQL monitoring features.
  
  Solution:
  To resolve this issue, you need to enable the SQL Monitor by changing the relevant profile parameter. Here are the steps to do this:
  
  
  Access the SAP System Profile Parameters:
  
  Use transaction code RZ10 to access the profile parameters.
  
  
  
  Edit the Profile:
  
  Select the appropriate instance profile (usually the one for your application server).
  Click on "Change" to edit the profile parameters.
  
  
  
  Modify the Parameter:
  
  Look for the parameter sql/monitor/enable.
  Change its value from 0 to 1