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

[Alan Campin <alan0307d@xxxxxxxxx>]

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.