How to Identify Expensive SQL Statements?

1. Start ST05.
2. Switch on the SQL trace: “Trace on”.
3. Run the test program (in a different window).
4. Switch off theĀ  SQL trace: “Trace off”.
5. List the SQL statements recorded: “List trace”.

Now, view the SQL trace and check the execution plan.

If you are having performance issues, There are other tools you should also regard when performance problems show up:

  • Transaction SE30: The ABAP Profiler
  • Transaction DB01: Lockwait Situations
  • Transaction ST02: Buffer Statistics
  • Transaction ST04: Database Performance Analysis