Microsoft SQL Server 2000
Best Practices
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.