How to run performance trace on a program

[Former Member]

Hi All,

I need to run pefromance trace on a program that I will run in background. I think I have to use ST05 to run SQL trace. Could someone please confirm the steps?

1) Go to ST05

2) Activate trace with filter

3) Run the program in background

I am not sure about the steps after this. How do I view the report while trace is running? Should I wait till the program ends to view the report? It is taking a long time to run. Should I do any other performance analysis other than ST05?

Thanks.

Mithun

[Former Member]

hi,

1) Go to ST05

2) Activate trace with filter

3) Run the program in background

4) as you get the output.

5) go to ST05 nad deactivate the trace

6) click on analyse button.

[Former Member]

Hi,

Cjheck this link.

http://help.sap.com/saphelp_nw70/helpdata/en/5a/ace273ca0211d194b500a0c94260a5/content.htm

Procedure-

http://techbays.com/2008/06/05/sap-performance-analysis/

Regards,

Sujit

[Former Member]

Once you finish running ur report, stop the trace.Else it will still trace all the actions u r doing also.

After stoping the trace, just open the trace and analyse.By looking at the trace, u will get to know which query in which table is taking more time and try 2 tune accordingly.

Thanks

Kiran

[Former Member]

Hi,

Check this thread for ST05 for a program running in background.

Regards

Adil

[Former Member]

Hi Mithun.

I would like to suggest a few references,

[SDN Library - Standard Reference - How to analyze performance problems - Trace|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3fbea790-0201-0010-6481-8370ebc3c17d]

[SDN Library - Standard Reference for Performance Analysis in a Nutshell|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/86a0b490-0201-0010-9cba-fd5c804b99a1]

[SDN Library - Standard Reference - Best Practices for Performance Tuning|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1408d5f234]

Hope that's usefull.

Good Luck & Regards.

Harsh Dave

[Former Member]

hiiii

follow steps given below

enter tcode ST05

Activate trace

Run the program in background

Now again open ST05 and click on analysis button

regards

twinkal

[Former Member]

hi check this...

it is better to put the time stamp field for the select to capture the execution time for that select rather than using the st05