Hi,
None of these are actually 100% sufficient.
Some databases gives you an end-tag, but some do not.
If you put FLTR/ESCL/API/SQL into the same file, you can track the thread
and see when a call stopped by looking at the following row of the thread.
Sometimes though, internal things in the ARServer takes time that is not
possilbe to track...
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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:arsl...@arslist.org] On Behalf Of Frank Caruso
> Sent: Monday, November 15, 2010 11:38 AM
> To: arslist@ARSLIST.ORG
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
