Sequential Read Ahead

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 challenge. To understand why asynchronous I/O is so important, consider the CPU to I/O performance gap.  The…

11