September 16, 2004 at 8:51 am
I am trying to see the performance of my application< and i wanted to test how long the execution of stored procedures and the sql queries taking . And also i wanted to check the locks at the same.So while starting my tracing file what are the options i should select .
Thanks.
September 16, 2004 at 12:42 pm
Sahana,
The default trace configuration will capture this information for you. For SQL:BatchCompleted events and RPC:Completed events, the Duration column of the trace is the number of milliseconds of real ("clock") time that the event consumed. You can add other events, which may also include Duration data, but Duration is always the column to check. However, some events do not include Duration information. For example, SQL:BatchStarting does not have Duration information (which makes sense, because the batch has not completed yet when this event is posted).
Hope this helps,
Chris
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply