How to use /SDF/SQLM - SQL Monitor

SAP Transaction Code - Details

• Transaction Code: /SDF/SQLM

  Description: SQL Monitor

  Release: S/4HANA and ECC 6

• • Program: /SDF/SAPLZQLM

    Screen: 100

    Authorization Object:

  • Development Package: /SDF/ZQLM

    Package Description: Package for SQL Monitor

    Parent Package: /SDF/MAIN_7X

  • Module/Component: SV-SMG-DIA

    Description: Solution Manager Diagnostics

Smart SAP Assistant

• SAP Tcode: /SDF/SQLM - SQL Monitor

  
  Overview:
  The SAP transaction code /SDF/SQLM is used to access the SQL Monitor in SAP. The SQL Monitor is a tool that allows users to monitor and analyze the performance of SQL statements in the SAP system. It provides detailed information about the execution of SQL statements, including execution time, number of rows processed, and other performance metrics. 
  
  Functionality:
  The SQL Monitor provides a comprehensive view of the performance of SQL statements in the SAP system. It allows users to analyze the performance of individual SQL statements, as well as compare the performance of different statements. The SQL Monitor also provides detailed information about the execution of each statement, including execution time, number of rows processed, and other performance metrics. 
  
  Step-by-step How to Use:
  1. Enter transaction code /SDF/SQLM in the command field. 
  2. Select the desired database connection from the drop-down list. 
  3. Select the desired statement from the list of available statements. 
  4. Click on “Execute” to execute the statement and view its performance metrics. 
  5. Click on “Analyze” to analyze the performance of the statement and view detailed information about its execution. 
  6. Click on “Compare” to compare the performance of different statements and view detailed information about their executions. 
  7. Click on “Save” to save any changes made to the statement or its performance metrics. 
  
  Other Recommendations:
  It is recommended that users familiarize themselves with the features and functionality of the SQL Monitor before using it for production purposes. Additionally, users should ensure that they have sufficient privileges to access and use the SQL Monitor before attempting to do so.