eramgarden Posted June 16, 2005 Posted June 16, 2005 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? Quote
iebidan Posted June 24, 2005 Posted June 24, 2005 use Query Analyzer to check your code and use the Execution Plan to get a good idea on what's going with your SP's that's how I do it. Execution Planes gives you a really good report on each thing going on in your code. Quote Fat kids are harder to kidnap
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.