Kontakt

Ansicht
Dokumentation

RSSQDM03 - SAP DB: Display Snapshots from MONI

RSSQDM03 - SAP DB: Display Snapshots from MONI

PERFORM Short Reference   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.
SAP E-Book

Description

Online program

This program analyzes snapshots from the performance database MONI. Monitor data is displayed for a maximum of 3 weeks in the past.

Requirements

Call transaction ST04
Menu: Goto -> Activity -> Performance database -> Previous days

Output

  • Day, Time
Date and time of the snapshot
  • SQL commands, Commits, Prepares, Rollbacks
Number of corresponding commands since DB restart

Select the pushbutton "More" to output the following values

  • Cache hit rates in %, Phys. reads, Phys. writes
Hit rates on selected buffer
Number of physical read and write operations
  • Table scans, Log pages written, Lock collisions
Number of search operations on the whole table (since DB restart)
Number of log pages written (since last log save)
Number of lock collisions (since DB restart)

Select the pushbutton "Delta" to determine the differences between the snapshots. To get a bar chart of all the displayed values, select the pushbutton "Graphics".

Example






General Data in Customer Master   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 1413 Date: 20240601 Time: 103143     sap01-206 ( 17 ms )