Re: how to keep track of the running time of a stored procedure or a query

Visual Explain gives you details of every part of the query including the
total time and where it is spending all of its time.

On Wed, Jul 15, 2009 at 2:09 PM, Yan Zhang <yzhtech@xxxxxxxxx> wrote:

Question: I want to keep track of the running time of stored procedures.
For example, for any query, say "CALL myLib/mySP(p1,p2,p3);", how do I

know

how long time it ran?

I think SQL performance monitor should be good at it. But it usually

break

a
stored procedure down to several queries. I want to find a easy way to

know

the running time, so that I can do performance comparisons.


Thanks guys in advance!


yan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.