How to use ST04 - DB Performance Monitor

SAP Transaction Code - Details

• Transaction Code: ST04

  Description: DB Performance Monitor

  Release: S/4HANA and ECC 6

  Menu Path:

  • Tools > Administration > Monitor > Performance > Database > Activity
  • Tools > CCMS > Control/Monitoring > Performance > Database > Activity

• • Program: RSDB0004

    Screen: 1000

    Authorization Object: S_ADMI_FCD

  • Development Package: STUN_DBA

    Package Description:

    Parent Package:

  • Module/Component:

    Description:

Smart SAP Assistant

• SAP Tcode: ST04 - DB Performance Monitor

  
  Overview:
  ST04 is a transaction code in SAP that is used to monitor the performance of the database. It provides an overview of the database performance and allows users to identify and troubleshoot any issues that may be affecting the system. 
  
  Functionality: 
  ST04 provides a comprehensive overview of the database performance, including information on the number of active users, the number of database requests, and the response time for each request. It also provides detailed information on the system resources being used, such as CPU utilization, memory usage, and disk space. Additionally, it allows users to view detailed information on individual database objects, such as tables and indexes. 
  
  Step-by-step How to Use: 
  To use ST04, first open the transaction code in SAP. Then select the database you want to monitor from the drop-down menu. You can then view an overview of the database performance or select a specific object to view more detailed information. You can also use the filters to narrow down your search results. 
  
  Other Recommendations: 
  It is recommended that users regularly monitor their databases using ST04 to ensure optimal performance. Additionally, users should be aware of any changes in their system resources or database objects that could affect performance. Finally, users should be familiar with SAP's documentation on ST04 so they can properly interpret and troubleshoot any issues they may encounter.