topic Re: Trace database selection in Application Development and Automation Discussions

Trace database selection

Former Member — Thu, 30 Jul 2009 07:59:15 GMT

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.

Re: Trace database selection

Former Member — Thu, 30 Jul 2009 08:00:40 GMT

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

Re: Trace database selection

Former Member — Thu, 30 Jul 2009 08:00:48 GMT

Hi,

Check using Tcode ST05 SE30

Re: Trace database selection

Former Member — Thu, 30 Jul 2009 08:01:09 GMT

Hi,

Use T.codes St05 & se30.

Thanks.

Re: Trace database selection

Former Member — Thu, 30 Jul 2009 08:10:19 GMT

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.

Re: Trace database selection

Former Member — Thu, 30 Jul 2009 08:10:45 GMT

HI,

Use ST05 transaction

regards,

bhavana

Re: Trace database selection

Former Member — Thu, 30 Jul 2009 08:11:32 GMT

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

Re: Trace database selection

Former Member — Thu, 30 Jul 2009 08:16:16 GMT

Thanks a lot