When does physical reads include read-ahead reads in SQL Server?
Category:
query-performance
, sql-server
SQL Server has more than one way to pull pages in from disk for your queries. SQL Server can do a physical read of an 8KB page, or an extent of 8 of those 8KB pages.