How to use /SDF/ZQLM - SQL Monitor

/SDF/ZQLM - Overview

• Transaction Code: /SDF/ZQLM

  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

/SDF/ZQLM - Details

• SAP Tcode: /SDF/ZQLM - SQL Monitor

  
  Overview:
  The SAP transaction code /SDF/ZQLM 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 the time taken for execution, the number of rows affected, and the number of database requests. 
  
  Functionality:
  The SQL Monitor provides a comprehensive overview of all SQL statements executed in the system. It allows users to analyze the performance of individual SQL statements and identify potential performance issues. The SQL Monitor also provides detailed information about the execution of each statement, including the time taken for execution, the number of rows affected, and the number of database requests. 
  
  Step-by-step How to Use: 
  1. Enter transaction code /SDF/ZQLM in the command field. 
  2. Select “SQL Monitor” from the drop-down menu. 
  3. Select “Display” from the toolbar to view a list of all SQL statements that have been executed in the system. 
  4. Select an individual statement to view detailed information about its execution, including time taken for execution, number of rows affected, and number of database requests. 
  5. Use this information to analyze and optimize the performance of individual SQL statements. 
  
  Other Recommendations: 
  It is recommended that users regularly monitor and analyze their SQL statements using the SQL Monitor tool