Assessment of Database Stored Procedures

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.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.c...icles_audit.asp for a
systematic approach

--

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

"Umar Reyi" <iyerra@.indiatimes.comwrote in message
news:1177366044.733092.100680@.y80g2000hsf.googlegr oups.com...

Quote:

Originally Posted by

>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.
>