topic Re: ST05 in Application Development and Automation Discussions

ST05

Former Member — Wed, 14 Feb 2007 06:02:30 GMT

Hi ,

Say for Example i am using some queries in SE38 , How to trace that using ST05 ?

How to do SQL Trace step by step ?

Re: ST05

Former Member — Wed, 14 Feb 2007 06:06:10 GMT

Hi,

SQL trace is used to find out the database requests that a transaction made during its processing. you can find out the tables been used.

you can do this by opening the tcode 'ST05' and selecting the 'TRACE ON'.

now execute your transaction. Again go to 'ST05' and do

'TRACE OFF' and 'LIST TRACE' to view the trace.

Check this link

reward points if this helps

Re: ST05

Former Member — Wed, 14 Feb 2007 06:06:22 GMT

SQL Trace (ST05) we use for performance tuning

In se38,you have a report and you want to test the performance of that report

ST05 tells about the summary of sql statements used in that program.

-Go to Tcode ST05

-Select Trace on

-In se38,Execute your report-

-Come back to st05 and select Trace off

-Select Trace list.

Now you check your select stmnts and how much time taking

-Some columns showing pink color are expensive select stmnts

You have so many options inside to check for summary and also index..

Hope it will be useful.

Thanks

Re: ST05

Former Member — Wed, 14 Feb 2007 06:07:58 GMT

Hi,

check this detailed document:

http://www.datamanagementgroup.com/resources/Articles/Article_1105_5.asp

regards,

keerthi

Re: ST05

Former Member — Wed, 14 Feb 2007 06:08:13 GMT

Hi kunar,

u can rfer to below links for help on SQL trace

1.http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

2.help.sap.com/saphelp_webas620/helpdata/en/d1/801f89454211d189710000e8322d00/content.htm

3.www.sap-img.com/ab016.htm

4.www.sapdb.org/7.4/htmhelp/5e/4dfca06fc1ea4ea31c0c522c62cb1a/content.htm

I hope this solves ur problem

Regards.

Note: Reward if useful

Re: ST05

Former Member — Wed, 14 Feb 2007 06:15:57 GMT

Hi Kumar,

first goto ST05 t.code and select SQL trace and click on Activate trace button

then goto SE38 and execute ur program

then back to ST05 t.code and Deactivate trace and Display trace.

reward if useful.

Re: ST05

Former Member — Wed, 14 Feb 2007 06:17:36 GMT

Hi ,

When i type to find about SQL in ST05

Select * From Vbak , It shows Time .

But

Select single * From Vbak ( It shows error in Sql )

How to test the second case ?

Re: ST05

anversha_s — Wed, 14 Feb 2007 06:28:45 GMT

hi,

chk this.

http://www.sapdevelopment.co.uk/perform/perform_sqltrace.htm

Regards,

Anver