SAP® Documentation

Single view

/SDF/ZQLM_DISPLAY_DATA - SQL Monitor: Data Display

Addresses (Business Address Services)   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.
SAP E-Book

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:

  1. Launch transaction /SDF/ZQLM.
  2. On the initial screen, check the status of the servers in the current system.
  3. Activate individual server instances # if required.
  4. Choose Display Data (launches transaction /SDF/ZQLMD automaticall
  5. Specify the options for the object selection, the SQL monitoring data, and for displaying the findings.
  6. Choose Execute (F8).
  7. On the SQL Monitor Results screen, identify and analyze the performance hotspots.

Selection

Standard Variants

Output

Activities

Example






Vendor Master (General Section)   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 4857 Date: 20200222 Time: 122621     sap01-206 ( 32 ms )

Our Service

Looking for Support? Questions?

The

Consolut

Callback-Service

Leave us your contact details and we will call you back. Panels marked with * are mandatory.