SET STATISTICS IO
Displays the amount of disk activity that was generated by a query.
Meaning of output:
• Logical reads—Number of pages read from the buffer pool.
• Physical reads—Number of pages read from disk.
• Read-ahead read— Read-ahead is a performance optimization mechanism that anticipates the needed data pages and reads them from disk. It can read up to 64 contiguous pages from one data file.
• Lob logical reads—Number of large object (LOB) pages read from the buffer pool.
• Lob physical reads—Number of LOB pages read from disk.
• Lob read-ahead reads—Number of LOB pages read from disk using the read-ahead mechanism.