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. Dirty Page Latency ​​ – A page is considered dirty when data modifications have taken place.

Servers 40