topic Re: Runtime analysis in Application Development and Automation Discussions

Runtime analysis

Former Member — Tue, 26 Feb 2008 07:26:43 GMT

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?

Re: Runtime analysis

Former Member — Tue, 26 Feb 2008 07:37:37 GMT

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.

Re: Runtime analysis

Former Member — Tue, 26 Feb 2008 08:13:46 GMT

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

Re: Runtime analysis

Former Member — Tue, 26 Feb 2008 09:09:09 GMT

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

Re: Runtime analysis

Former Member — Tue, 26 Feb 2008 09:15:50 GMT

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