Remove 2004 Remove Benchmarking Remove Latency Remove Programming
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. In versions ​​ earlier than ​​ SQL Server 2004 SP4, SQL Server latch enforcement protection involved more protection transitions.

Servers 40