article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

This White Paper is for informational purposes only. For ​​ more information about ​​ I/O ​​ caching requirements ​​ and SQL Server, see the following ​​ white papers on MSDN.

Servers 40
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

This White Paper is for informational purposes only. Many high-end disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. Speed Changes The compression overhead also results in I/O performance bottlenecks. This cache is often supported by a battery-powered backup facility.

Servers 40