Program performance

[Former Member]

Hi,

I have a complex program that is going to multiple tables and hence the program is very very slow. How can i find out which select statement is taking the longest time?

Vartika.

[Former Member]

You can go to the transaction ST05.

ACtivate the trace and run your program and swith the trace off (ST05)

Then display the trace using ST05. It tells you what selec is taking too much time.

Regards,

Ravi Kanth Talagana

[Former Member]

SE30 is good for performance analysis. Run your program through that transaction.

[Former Member]

Okay, I ran it using SE30. I see the normal output displayed that I see when i run thr program in SE38. How do i do the analysis??

[Former Member]

See the help files regarding SE30 for a full explanation.

The short version is this. All you really need to do is go to SE30 and execute your program from there. Once you get the output, green arrow back until you get back to SE30. Now you should be able to click the Evaluate button at the bottom. Once you get to the next screen, click the Hit List button for a full breakdown of where the time was spent. This will report selects, function calls, etc.

I usually prefer to sort it by the Net time, so I can see the big concerns right at the top. You can even get to the ABAP code by putting your cursor on a row and clicking the Display Source Code button.

[Former Member]

Dear Vartika,

Transaction Code ST05 will take you to Perfomance Analysis, there you can make use of SQL Trace . It allows you to see how the OPEN SQL statements that you use in ABAP programs are converted to standard SQL statements ( and the parameters with which the embedded SQL statements are passed to the database system.

Best Regards,

Rajesh

Please reward points if found helpful.

[Former Member]

Hi Vartika

try ST04. Since you program access many tables, by runnings statistics for the table, the performance will increase

Cheers

~Arun

[kiran_k8]

Vartika,

I guess you can even use SM50 to analyse where actually it is taking time to process the data.Run the program in se38 and then check in SM50.

K.Kiran.