07-30-2009 8:59 AM
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.
07-30-2009 9:00 AM
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
07-30-2009 9:00 AM
07-30-2009 9:01 AM
07-30-2009 9:10 AM
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.
07-30-2009 9:10 AM
07-30-2009 9:11 AM
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
07-30-2009 9:16 AM