SQL Performance Tuning Worklist

The SQL Performance Tuning Worklist (transaction SWLT) enables you to find ABAP SQL code that has potential for performance improvement. This tool combines information from static ABAP code scans that normally run in a test or quality system with runtime data from the SQL Monitor that typically originates from the productive system. Based on data records collected by the SQL Monitor, the SQL Performance Tuning Worklist automatically creates a worklist and allows you to rank the findings according to specific performance issues and their business relevance.

Overview of Features Provided

The main purpose of the SQL Performance Tuning Worklist is to facilitate the evaluation of runtime data originating from SQL Monitor in order to identify promising candidates for performance tuning.

In addition to the SQL Monitor, the SQL Performance Tuning Worklist allows you to …

Combine the SQL monitoring data with findings of local or remote static performance checks that refer to the executed SQL statements.
Restrict the result list to statements for which static performance check findings exist.
Evaluate monitoring data snapshots of the local or a remote AS ABAP system. You can create snapshots of SQL data directly from the local system or by specifying the RFC destination.
Import (Upload) the SQL Monitor recordings from a local file that you previously exported from the productive system.
Evaluate data from Code Coverage if no SQL Monitor data is available in the system.
Display a condensed (overview) list of findings that are sorted in accordance with the selected performance indicators.
Display views with results from static checks and with SQL runtime data.
Navigate to and directly change the affected ABAP source code.