SQL Performance Monitoring

What utilities can I avail of in order to efficiently check the existing ABAP code for SQL performance issues?

Within the SAP NetWeaver AS for ABAP, there are already many tools that can assist you in performance optimization of ABAP programs. For instance, the ABAP Runtime Analysis tool (SAT) and the SQL Trace tool (ST05) can be used to examine the performance of ABAP programs and the database accesses executed in ABAP statements.

These standard tools are complemented by new specialized tools and utilities that can significantly ease performance analysis and allow you to monitor exactly those parts of the system that are relevant for running your business scenarios. You can use them to analyze the SQL profile of your business processes in a productive system, even for a longer period of time (over several days or even weeks). This enables you to determine how frequently and along which access paths certain database tables are accessed, and how much time is spent for the data access.

Furthermore, the new tool set provides you with enhanced capabilities to identify ABAP code that does not adhere to the classic performance guidelines for database access programming in ABAP (Standard Open SQL and Native SQL interface).

The new tools also provide you with additional views on data that may result from different data sources: they combine static data from ABAP code scans (ABAP Test Cockpit or Code Inspector) with runtime data (SQL Monitoring), and automatically create a condensed worklist. The resulting findings allow you to rank the worklist according to specific performance issues and your business relevance.