topic Re: How to make a trace to program ? in Application Development and Automation Discussions

How to make a trace to program ?

former_member425121 — Wed, 17 Jan 2007 17:17:03 GMT

Does somebody can tell me how can i make a trace to program in order to find in wich code point the process is getting 'stand-by' (does not finish) ; that is, in wich DB access, LOOP, etc. the program is making the work wich takes a lot of time.

I need to discover where are the performance problems and how much the program access the DB with SELECTS.

Regards

Frank

Re: How to make a trace to program ?

RichHeilman — Wed, 17 Jan 2007 17:19:27 GMT

Transacation ST05 will allow you to do a SQL trace showing all of the DB hits during the program runtime.

Regards,

Rich Heilman

Re: How to make a trace to program ?

Former Member — Wed, 17 Jan 2007 17:24:48 GMT

Hi,

You can use ST05 for SQL trace..

You can also use SE30 for runtime analysis..

Thanks,

Naren

Re: How to make a trace to program ?

Former Member — Wed, 17 Jan 2007 17:26:16 GMT

Hi,

make use of the transaction code ST05 for the trace of database selects, Just press the Trace on button and run your program, and inthe ST05, press the Trace off button and look at the list, you will understand.

Even you can use the transaction ST04 -> Database performance analyzer

ST03 -->Workload on the System

Regards

Sudheer

Re: How to make a trace to program ?

former_member425121 — Wed, 17 Jan 2007 18:00:35 GMT

Thanks ..