Remove 2004 Remove Benchmarking Remove Latency Remove Virtualization
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. © ​​ 2004 Microsoft Corporation. ​​ All rights reserved.

Servers 40
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

The caching of data pages and grouping of log records helps remove much, if not all, of the command latency associated with a write operation. ​​ The following table outlines the virtual protection states. Page State Virtual Protection State Dirty Read Write ​​ during the modification.

Servers 40