Analyze SPS

What is the program microsoft has developed to help optimize Stored
procedures? (I am not talking about the quesry analyzer).
SeanSean,
You might not be talking about Query Analyzer, but that is what we
have and what we use. In particular, the graphical query plan feature
of Query Analyzer is indispensible.
There is also the Index Tuning Wizard. Search Books on Line for
details. Tuning a query, or a proc, is often a case of indexing
properly.
Roy
On Fri, 28 Apr 2006 13:07:53 -0700, <Seanms@.keeyon.com> wrote:

>What is the program microsoft has developed to help optimize Stored
>procedures? (I am not talking about the quesry analyzer).
>Sean|||Seanms@.keeyon.com wrote:
> What is the program microsoft has developed to help optimize Stored
> procedures? (I am not talking about the quesry analyzer).
> Sean
Profiler for example. It will help you track down performance-critical
pieces of code. Could you explain what sort of functionality you are
looking for that isn't otherwise in QA?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--