SQLUSA

Microsoft SQL Server 2000

Best Practices

 

How to determine the number of reads in a stored procedure?

 

Set statistics io on before execution is one way in Query Analyzer.

Setting up a trace in SQL Profiler is the second way.

Typical stored proc can 100-500 reads. If it's doing a lot more it is a candidate for optimization.

 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page