topic Re: sql trace in Application Development and Automation Discussions

sql trace

Former Member — Tue, 11 Jan 2005 11:36:25 GMT

dear all,

the sql trace ( st05) in SAP shows different execution time values when i run the query at different times. Is the execution time shown dependent on the network load? and what does all the fields of sql trace output mean?

Re: sql trace

Former Member — Wed, 21 Dec 2005 15:17:05 GMT

Hi Prabaharan,

Database access times higher at certain times can be generated by throughput problems in the network.

Please do not forget to run the application at least once before starting the measurement, in order to fill the buffers.

I do not know whether I understood the second question rightly, but here are some field descriptions:

Columns in SQL trace:

Duration - SQL statement runtime in microseconds

Object - DB table or view name

Oper - operation executed (e.g. open, fetch)

Rec - number of records read from the DB

RC - database specific return code

Statement: - short form of SQL statement

hh:mm:ss.ms - time stamp

Program - program generating the SQL statements

Curs - database cursor number

The above given info is taken from ''SAP Performance Optimization Guide' (ISBN 1-59229-022-1).

Hope this helps,

Ferenc

Re: sql trace

Former Member — Wed, 21 Dec 2005 15:34:39 GMT

If you want to compare performance for different selects, the best tool is the 'explain' function in the trace. Put your cursor on a line in the trace doing an 'open' and then press the explain button. The estimated cost should remain constant for identical selects under different network loads.

Rob

Re: sql trace

Former Member — Wed, 21 Dec 2005 15:50:45 GMT

Hi, the execution time varies depending upon the server load and the buffer. To have an idle execution time, better log off and then execute. As whenever the program is first executed, there would be no buffer and I think we can consider this time to be the idle time . From the second execution onwards, as the buffer would be already available, the time would be less than the first time execution. Hope this helps.

Re: sql trace

Former Member — Fri, 02 Nov 2007 16:15:55 GMT

Answers were useful