Don’t be surprised if you found that there is huge different on reads count between “SET STATISTICS IO” and Profiler reads. For example:

Query A, use statistics IO, it shows 30 reads.
Same query, use profiler, it shows 500 reads.

The read will be different as profiler will give you the total read, including the logical read, physical read, readaheads etc. By Statistic IO, you can see each read seperately on the Message Pane.
io

Advertisements