Hi,
I'm using some stored procedures for maintenace purposes at my production database. The next table is taken from quey analyzer. (data taken from sniffer)
I did run a procedure once yesterday, started at 16:09, run ended at 16:28 (as seen also from First seen and Last seen columns). But, I did run it ONCE – analyzer showing 496 as count, why?
Also the queries inside the procedure are are totally missing from query analyzer data. Query executien times are also bizarre, Running the procedure took about 20 minutes!
Query Execution Time
(hh:mm:ss.ms)
Count
Query Occurrence(%)
First Seen
Last Seen
Query
Total
Avg
Max
06.000
0
01.000
496
52.991
Feb 27, 14 16:09:19
Feb 27, 14 16:28:28
CALL `my_procedure`()