hi

I have 40 SP, most of them are symple, but I want to get the most

What tools can you recomend to analyze my SP and get suggestions about
performance?

thks

One of my all-time favorites is the Execution Plan function in QA... It
gives you pretty good hints as to where the bottlenecks are in your queries
and SPs.

"Kenny M." <KennyM (AT) discussions (DOT) microsoft.com> wrote

I'm agree with you.
But is it possible to debug SP? Can you tell me how to do it?

Thanks

Ahhh debugging. I go old school on that. I think I read that you can use
VS.NET to debug SP's, but I haven't had a need to do that yet. Someone else
would have to give you the specifics. You might find more info on the
wherefore's and how-to's on MSDN...

"Resant" <resant_v (AT) yahoo (DOT) com> wrote

I don't find much value in it personally (PRINT and RAISERROR work pretty
well for me). But Query Analyzer is capable of debugging... see
http://www.aspfaq.com/2455 for a little bit of info.

--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.




"Resant" <resant_v (AT) yahoo (DOT) com> wrote