topic Re: SQL Trace in Application Development and Automation Discussions

SQL Trace

Former Member — Wed, 02 Apr 2008 05:10:31 GMT

pl..tell me how to use SQL trace and observe the results..

Re: SQL Trace

Former Member — Wed, 02 Apr 2008 05:13:52 GMT

SQL trace

http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

Re: SQL Trace

Former Member — Wed, 02 Apr 2008 05:19:41 GMT

hi,

Submit ABAP report with SQL traces

You use ST05, Trace Request, to do a SQL trace.

When using SQL trace, it is good to run the program in debugger and just before you execute the SQL, go to ST05 in another session and turn the trace on.

After, or when, the SQL is finished, you can turn the trace off.

Then click on List Trace to see the details.

This is the way to control the traces.

If you just turn the trace on and then execute the program, you will get everything and will be overflooded with unnecessary information.

Hope this helps, Do reward.

Re: SQL Trace

Former Member — Wed, 02 Apr 2008 15:27:09 GMT

why do not just read the most recent questions, the same question was asked yesterday!

I can only recommend you my blog, it explains all you need

/people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy

> When using SQL trace, it is good to run the program in debugger and just before you execute the SQL, go to ST05 in another > session and turn the trace on.

> After, or when, the SQL is finished, you can turn the trace off.

> Then click on List Trace to see the details.

> This is the way to control the traces.

> If you just turn the trace on and then execute the program, you will get everything and will be overflooded with unnecessary

> information.

sorry, bad idea, much to complicated and misleading! Often you don't know what statement creates the problem, and usually it is not one problem.

Read the blog carefully, the condensed view (section 3 ) makes this complicated approaches obsolete.

Siegfried

Re: SQL Trace

Former Member — Wed, 02 Apr 2008 15:32:32 GMT

Hi,

ST05 -> SQL Trace can be used for performing SQL statement analysis..

Check this link..

http://www.sapbrain.com/TOOLS/SQLTRACE/SQL_TRACE.html

Refer

https://forums.sdn.sap.com/click.jspa?searchID=10333986&messageID=3558350

Regards

Kiran Sure