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

If you run Visual Explain when you exit it gives you the option of saving
the data. I don't know if there are other places data is stored.

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

Which table under which schema stores this kind of statistical information?

On Wed, Jul 15, 2009 at 4:19 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

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.

--
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.