Ansicht
Dokumentation
/SDF/ZQLM_DISPLAY_DATA - SQL Monitor: Data Display
ABAP Short Reference PERFORM Short ReferenceThis documentation is copyright by SAP AG.
Purpose
The SQL Monitor allows for tracing all SQL statements executed by running ABAP applications. The SQL Monitor trace contains aggregated performance indicators (number of executions, execution time, number of effected rows, etc.) for all executed OPEN SQL and native SQL statements. In contrast to the standard Performance Trace (transaction ST05), the SQL Monitor enables you to perform such traces even over a longer period of time. In addition, you can expand the scope of the analysis to finding system-wide hotspots. Other than for mere DB monitoring, the reference to the ABAP context is always retained: For each SQL trace record, the entry point of the responsible request (transaction code, submitted report, RFC function module, etc.) is stored, too. This provides a first connection from the SQL statement to the responsible business process.
On base of the data records collected by the SQL Monitor, the SQL Performance Tuning Worklist (transaction SWLT) allows you to derive more sophisticated conclusions on potential performance improvements.
The SQL Monitor offers two different transactions:
- transaction /SDF/ZQLM targets administrative tasks
- transaction /SDF/ZQLMD serves for data record analysis
Integration
Prerequisites
- In order to use the functionality of these transactions, you need in the relevant system:
- Display authorization profile for object S_DEVELOP (activity:03)
- Authorization profile for object S_ADMI_FCD with value ST0R for read access to SQL Monitor data
- Authorization profile for object S_ADMI_FCD with value ST0M for SQL Monitor administration
- The report /SDF/RZQLM_UPDATE_DATA should run periodically (e.g. once per hour) in the relevant system. It makes the data collected by the monitor available for read access.
Monitor Administration - Transaction /SDF/ZQLM
Getting Server Status Information
For all server instances of an ABAP system, you can view the status information as to whether or not SQL Monitoring is active.
Changing Server Status
For each individual server instance, you can change the status by activating or deactivating the recording for that very server.
Activating All Servers
Without making any server selection, you can activate all server instances of a system for SQL monitoring.
Deleting SQL Monitoring Data
In one step you can delete all the SQL Monitor recordings that exist in the system.
Navigation to Data Selection for Analysis
Starting from the administrative view, you can navigate to transaction /SDF/ZQLMD using Display Data.
Monitor Data Analysis # Transaction /SDF/ZQLMD
Options for Object Selection
You can select development objects that are suitable for analysis of SQL monitoring data using various criteria. For example, you can limit the objects to a particular set of packages or a particular object type.
Options for SQL Monitoring
For your analysis, you can determine the request entry point of the processes or DB operations or even limit the scope to individual database tables.
Options for Results View
For displaying data results, you can also specify aggregation and ordering options.
Procedure # Main Steps
The typical procedure for working with SQL Monitor tools involves the following steps:
- Launch transaction /SDF/ZQLM.
- On the initial screen, check the status of the servers in the current system.
- Activate individual server instances # if required.
- Choose Display Data (launches transaction /SDF/ZQLMD automaticall
- Specify the options for the object selection, the SQL monitoring data, and for displaying the findings.
- Choose Execute (F8).
- On the SQL Monitor Results screen, identify and analyze the performance hotspots.
Selection
Standard Variants
Output
Activities
Example
RFUMSV00 - Advance Return for Tax on Sales/Purchases Fill RESBD Structure from EBP Component Structure
This documentation is copyright by SAP AG.
Length: 4857 Date: 20240425 Time: 224102 sap01-206 ( 75 ms )
