How to make a trace to program ?

[former_member425121]

Hi

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

[former_member425121]

Hi

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

[RichHeilman]

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

Regards,

Rich Heilman

[Former Member]

Hi,

You can use ST05 for SQL trace..

You can also use SE30 for runtime analysis..

Thanks,

Naren

[Former Member]

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

[former_member425121]

Thanks ..