Trace database selection

[Former Member]

Hi experts,

I need to check a program which has performance problems. It works with large database tables. Is there any possibility to trace which statements slows the program execution, or how to figure it out what is the cause of the performance problem. I think I found the statement, but I'm not sure about it.

[former_member555112]

Hi,

Use the transaction ST05.

Activate the trace via ST05 for your user.

Then run your program in a separate session.

After that deactivate the trace when your program finishes and then display the trace results.

Regards,

Ankur Parab

Edited by: Ankur Parab on Jul 30, 2009 1:30 PM

[Former Member]

Hi,

Check using Tcode ST05 SE30

[Former Member]

Hi,

Use T.codes St05 & se30.

Thanks.

[Former Member]

Okay, I've already used st05, but it's not enough in my case, since it is a very long running program.

SE30 it also not a solution for me, because all you can do with this transaction to measure the runtime.

The program wich I try to run is giving a time_out.

[Former Member]

HI,

Use ST05 transaction

regards,

bhavana

[Former Member]

HI,

You can execute your program in SE30 and then click on Analysis after getting output.

It will show the complete detail of ABAP Effort, DATABASE effort, R/3 Effort.

Selecting TOP left Icon on the screen.

It will display the Runtime Analysis.

Sort them in Descending Order as per Net Value.

Whichever Query takes more time, will come at the top.

Click on Editor 'Third Icon' by selecting the line, it will show the Query.

Regds,

Anil

[Former Member]

Thanks a lot