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

SAP Error Message - Details

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

Smart SAP Assistant

• What is the cause and solution for SAP error message SQLM024 - SQL Monitor is currently switched OFF by system profile parameter &1 ?

  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 to enable the SQL Monitor.
  
  
  
  Save Changes:
  
  Save the changes to the profile.
  
  
  
  Restart the SAP System:
  
  For the changes to take effect, you will need to restart the SAP instance.
  
  
  
  Verify the Change:
  
  After the restart, you can verify that the SQL Monitor is enabled by checking the parameter value again in transaction RZ10 or by using the SQL Monitor functionality.
  
  
  
  Related Information:
  
  SQL Monitor Usage: The SQL Monitor is a powerful tool for performance analysis and optimization of SQL statements in SAP systems. It helps in identifying long-running queries, analyzing execution plans, and understanding database performance.
  Performance Considerations: Enabling the SQL Monitor may have an impact on system performance, especially in high-load environments. It is advisable to monitor the system performance after enabling this feature.
  Documentation: For more detailed information, refer to the official SAP documentation regarding SQL Monitor and performance tuning.
  
  By following these steps, you should be able to resolve the SQLM024 error and enable the SQL Monitor in your SAP system.