topic SQL trace for a report program in Application Development and Automation Discussions

SQL trace for a report program

Former Member — Tue, 25 Nov 2008 11:29:09 GMT

hello friends,

i want to know how to perform SQL trace for report program. As im asked to find why its taking long time to display the report output. Please explain me clearly how to use ST05 transaction code to check performance.

thank you

regards

vijay

Re: SQL trace for a report program

Former Member — Tue, 25 Nov 2008 11:34:06 GMT

Hi Vijay,

Thire is no fixed method to find which is taking longer time as with the case ST05.

lets say for lengthy and complex query the load on the server is very less and executed fastly then a simple query comes then system is heavily loaded then it takes longer time

this is not a reliable method.

there is a get run time FM to assess the run time but there also the same problem and each time you run it you will get different values.

regards

Ramchander Rao.K

Re: SQL trace for a report program

Former Member — Tue, 25 Nov 2008 11:34:28 GMT

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.

Regards

Renu

Re: SQL trace for a report program

Former Member — Tue, 25 Nov 2008 11:36:48 GMT

Hi Vijay,

Just go through the following link:

Please check this link also, perhaps it may help.

http://help.sap.com/saphelp_nw04/helpdata/en/17/358df9c9fee2469105731e10756921/frameset.htm

Regards,

Nitin.

Re: SQL trace for a report program

GauthamV — Tue, 25 Nov 2008 11:38:31 GMT

hi,

check this.

[https://forums.sdn.sap.com/click.jspa?searchID=19132544&messageID=3044863]

Re: SQL trace for a report program

Former Member — Wed, 26 Nov 2008 03:39:04 GMT

Thank you

vijay