Craig Freedman's SQL Server Blog

A discussion of query processing, query execution, and query plans in SQL Server.

September, 2008

Posts
  • Craig Freedman's SQL Server Blog

    Sequential Read Ahead

    • 9 Comments
    Balancing CPU and I/O throughput is essential to achieve good overall performance and to maximize hardware utilization. SQL Server includes two asynchronous I/O mechanisms - sequential read ahead and random prefetching - that are designed to address this...
Page 1 of 1 (1 items)