How to use SQLM - SQL Monitor

SQLM - Overview

• Transaction Code: SQLM

  Description: SQL Monitor

  Release: S/4HANA and ECC 6

• • Program: SAPLSQLM

    Screen: 100

    Authorization Object:

  • Development Package: SQLM_UI

    Package Description:

    Parent Package:

  • Module/Component:

    Description:

SQLM - Details

• SAP Tcode: SQLM - SQL Monitor

  
  Overview:
  SQLM is an SAP transaction code used to monitor the performance of SQL statements in the SAP system. It is used to analyze the performance of SQL statements and identify any potential issues that may be causing poor performance. 
  
  Functionality: 
  SQLM provides a graphical overview of the performance of SQL statements in the SAP system. It displays the execution time, number of executions, and other information related to each statement. It also allows users to compare the performance of different statements and identify any potential issues that may be causing poor performance. 
  
  Step-by-step How to Use: 
  1. Enter transaction code SQLM in the command field. 
  2. Select the “SQL Monitor” option from the menu. 
  3. Select the “Execution Time” tab to view a graphical overview of the performance of SQL statements in the SAP system. 
  4. Select a statement from the list to view detailed information about its performance. 
  5. Select the “Compare” tab to compare the performance of different statements and identify any potential issues that may be causing poor performance. 
  6. Select the “SQL Trace” tab to view a trace of all SQL statements executed in the SAP system. 
  7. Select a statement from the list to view detailed information about its execution trace. 
  8. Select the “Statistics” tab to view statistical information about all SQL statements executed in the SAP system. 
  9.