SQL trace for a report program

[Former Member]

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

[Former Member]

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

[Former Member]

Thank you

vijay

[Former Member]

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

[Former Member]

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.

[GauthamV]

hi,

check this.

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