Monitoring Stored Procs

E

eramgarden

Well-known member
Joined
Mar 8, 2004
Messages
579
Ok, at this new job of mine, we have 10 something stored procs. DBA says there are performance issues with a lot of them...he said maybe 400 but he doesnt know which ones...

I know I can turn on Profiler and look at Stored procs. ( he has profiler running all day long)..but what I want to find out is can I turn on Profiler (or something) on specific Stored Procs (or a set of stored procs) to see loops, exception path, etc ??

Basically What is the best way of monitoring SPs and finding out which ones need redesign and tuning etc?
 
use Query Analyzer to check your code and use the Execution Plan to get a good idea on whats going with your SPs thats how I do it. Execution Planes gives you a really good report on each thing going on in your code.
 
Back
Top