Optimizing Performance

Optimizing Database Access

Efficient programming is first and foremost based on optimal database access. You can achieve this through effective use of the SELECT statement.

To display examples of how you can attain optimal performance, choose Test ® Runtime analysis from the ABAP Workbench (or Transaction SE30), then choose Tips & Tricks. In the SQL interface group box, you will find examples of how to use the SELECT statement.

Using SQL Trace and the Runtime Analysis Function

To check the performance of your ABAP functions, use the SQL trace or runtime analysis utilities. Choose System ® Utilities ® SQL trace or System ® Utilities ® Runtime analysis. For further information about these tools, consult the ABAP Workbench Tools section of the R/3 online documentation.

Using the Workload Statistics

To check your system performance, check the workload statistics. You can display the workload statistics for the server on which you are currently working, for another server, or for all servers. The statistics provide detailed information about response times and resource use.

To access the workload statistics, choose Tools ® Administration, then Monitoring ® Performance and Workload ® Analysis (ST03).

You can carry out the workload analysis for any of the following:

If you encounter an acute problem, start by analyzing the current day.

The transaction profile gives the average behavior of a transaction. You should pay particular attention to the transactions which take up most database time. You can usually reduce the system load and improve performance considerably by analyzing the three to five transactions taking up the most database time.

For help interpreting the performance monitor, choose Help ® Application help from the relevant transaction.