Frank, SQL Queries are correlated via TID (Thread ID). If you look for a specific query, and then look for the next instance of that thread ID the line should be 'OK'...the OK is the end of the SQL Query. If you are looking to perform general SQL timing, there are a number of tools on the BMCDN that will parse API/SQL logs and give you lots of good statistics. Contact me offline if you need specifics.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Monday, November 15, 2010 11:38 AM To: [email protected] Subject: SQL Timing Haven't had to do this in a while and thought I understood the logic but am confused about how, from an SQL log, can you tell how long the query took? I can see the query start but I don't see anything indicating when it finished. For an Update statement I see the commit. Frank ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
