Analyzing Database Accesses

Whenever the database portion of a runtime distribution is (unexpected) high, you may wish to find out, which database accesses in your application have caused this to happen.

Prerequisites

You have created an ABAP trace of your ABAP program. The ABAP trace has the state Finished.

Context

The Database Accesses tool allows you to identify and analyze the top consumers during database accesses. It provides you with a list of all database tables and table views that are used during the execution of the ABAP program in question. In addition, detailed information for each database access, such as access type, buffer settings, or duration of table accesses is provided.

Procedure

Open the ABAP Traces view.
In the view, expand the relevant project tree and double-click the trace entry. The Overview page appears for the selected trace.
Choose the Database Accesses tab.

Figure 1: The Database Accesses view provides you with details for each database access in your ABAP program

Results

Using the Databases Accesses view, you can...

Identify top consumers during the database accesses
Check which portion of runtime is used by database accesses from ABAP kernel or system events
Get a complete list of tables (views) that are used during the execution of you ABAP program
Check, where your program repeats the same database access
Analyze further details of each database access and check, for example, whether and how the tables are buffered
Navigate to the table (view) definition in the ABAP Dictionary.

Tip

To restrict the data in the view, you can enter the appropriate filter text or configure the view by using the context menu in the table header.

Figure 2: Configuring the view details using the context menu in the table header