Runtime analysis

[Former Member]

Hi,

Can anybody guide me for this ?

I want to perform runtime analysis for performance of a program but the program is updating something.

So whether it is applicable to go for se30?

[Former Member]

Hi,

I would recommend you go for SQL trace analysis using transaction ST05 and check how the DB table access is taking place and whether indexes are being used.

ST05 concentrates on DB reads and updates and since your program is doing that, I would recommend you check this.

Cheers.

[Former Member]

ST05 can be used, it shows which are db tables have been accesed.

Alternatively you can use ST12, which has combinatin of both ST05 & SE30

[Former Member]

The program is including the BDC updation , so how to analyse the problem , or just by checking each query .....

[Former Member]

You can do both SE30 and ST05

SQL trace:

/people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy

SE30

/people/siegfried.boes/blog/2007/11/13/the-abap-runtime-trace-se30--quick-and-easy

The SE30 tells whether ABAP or DB have more load, the SQL Trace becomes interesting when DB contributes a lot.

Read the blogs for details.

The ST12 is a Service Transaction and not automatically available in your system. It is just another view on the 2 traces.

Siegfried