Analyzing Database Access with SQL Trace

Objectives

After completing this lesson, you will be able to:

  • Start the SQL trace
  • Analyze SQL trace results

The SQL Trace

The SQL Trace is used to centrally monitor the entire traffic between the ABAP system and the database. You can activate and deactivate the trace from inside ABAP development tools. but to analyze trace results, you have to start the Technical Monitor Cockpit, a Browser-based application.

The SQL Trace is not restricted to a single user, client, or server instance. If there is more than one database connected to the system, it traces the traffic for all these databases.

In the Trace Result, you can display information about individual SQL statements, like the time consumption on the database or the number of records accessed. You can also analyze the native SQL syntax, that is, the statement in the form in which it reached the database.

Some restrictions apply when working with the SQL Trace. Only one user can switch the trace on at same time. And when you activate the trace from ABAP Development Tools there is no way to add recording filters.

Analysis of SQL Trace Results

In this video, you will see how to start an SQL Trace and analyze the result.

Note

We will discuss the Prepared Plan and Executed Plan tabs later in this course.

Log in to track your progress & complete quizzes