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

  • Show details Hide details
  • 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

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant