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
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.
Error message extract from SAP system. Copyright SAP SE.
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
Get instant SAP help. Sign up for our Free Essentials Plan.
SQLM023
Not able to retrieve SQL Monitor data
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
SQLM022
No authorization for "&1"
What causes this issue? System Response The system issues an error message and will not allow you to continue with this transaction until the error i...
SQLM025
Invalid value for profile parameter &1: No reliable SQL Monitor results
What causes this issue? The Workload Statistics function has been switched off by profile parameter "&V1&". Consequently, the SQL M...
SQLM026
&1 &2 records updated (runtime &3 seconds)
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
Click on this link to search all SAP messages.