How to use DB02_MSS - Db02 for MS SQL Server

SAP Transaction Code - Details

• Transaction Code: DB02_MSS

  Description: Db02 for MS SQL Server

  Release: S/4HANA and ECC 6

• • Program: SAPLSMSSCCMS

    Screen: 1500

    Authorization Object: S_ADMI_FCD

  • Development Package: STUN_MSS

    Package Description:

    Parent Package:

  • Module/Component:

    Description:

Smart SAP Assistant

• SAP Tcode: DB02_MSS - Db02 for MS SQL Server

  
  Overview:
  DB02_MSS is a SAP transaction code used to monitor the performance of a Microsoft SQL Server database. It provides an overview of the database's performance and allows users to identify and troubleshoot any issues. 
  
  Functionality: 
  DB02_MSS provides a comprehensive overview of the performance of a Microsoft SQL Server database. It displays information such as the number of active sessions, the number of locks, and the amount of memory being used. It also provides detailed information about the database's tables, indexes, and other objects. Additionally, it can be used to identify and troubleshoot any issues with the database. 
  
  Step-by-step How to Use: 
  1. Log into your SAP system and enter transaction code DB02_MSS. 
  2. Select the database you want to monitor from the list of available databases. 
  3. Review the performance overview for the selected database. 
  4. Select any of the available options to view more detailed information about the database's tables, indexes, and other objects. 
  5. Use this information to identify and troubleshoot any issues with the database. 
  
  Other Recommendations: 
  It is recommended that users regularly monitor their databases using DB02_MSS in order to ensure optimal performance and identify any potential issues before they become serious problems. Additionally, users should be familiar with all of the available options in order to get the most out of this transaction code.