Posted by Jack Vamvas on 04/24/07 15:02

It depends what you class as acceptable criteria. It depends on the nature
of the stored procedures.
For example, if it's a simple SELECT statement , returning it in 6 seconds
may be to slow for the end user., and could point to something else being
the problem.
Check http://www.sql-server-performance.com/articles_audit.asp for a
systematic approach

--

Jack Vamvas
___________________________________
Need an IT job? <a href="http://www.itjobfeed.com">uk it jobs</a>



"Umar Reyi" <iyerra@indiatimes.com> wrote in message
news:1177366044.733092.100680@y80g2000hsf.googlegroups.com...
>I am attempting to compile a list of questions that will enable me
> assess 'at risk' stored procedures that need to be remediated in order
> to minimize unplanned downtime and enhance database performance. Is
> there a subset of criteria (parameters) from the MS SQL Server Best
> Practices Analyzer that can be used for this purpose? Any pointers to
> the appropriate documentation is most welcome.
>
> Thanks in advance.
>

[Back to original message]