ST05

[Former Member]

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 ?

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

check this detailed document:

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

regards,

keerthi

[Former Member]

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

5.

I hope this solves ur problem

Regards.

Note: Reward if useful

[Former Member]

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.

[Former Member]

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 ?

[anversha_s]

hi,

chk this.

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

Regards,

Anver