jpoper
asked on
Stored procedure performance monitor
Is anybody aware of a performance monitor that allows the tracking of stored procedures, their execution times, IO ,and other related statistics?
ASKER
We are looking to track this information durring the processing day when the application executes the proc. We are have no performance problems when we test the procs but the application is having performance problems and we want to rule out the procs.
cant you set the monitoring for the complete day?
I dont recall the syntax from the top of my head,
but I know you can set something like
sp_monitor 8:00:00 (set collecting stats for 8 hours)
Somebody else here can surely fill this in right now.
Best of times!
I dont recall the syntax from the top of my head,
but I know you can set something like
sp_monitor 8:00:00 (set collecting stats for 8 hours)
Somebody else here can surely fill this in right now.
Best of times!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try executing the following statements before running your stored proc.
set statistics io on
set showplan on