Remove 2004 Remove Benchmarking Remove Latency Remove Network
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

url=/library/en-us/fileio/fs/sparse_files.asp ) ​​ on the ​​ Microsoft Developer Network ​​ (MSDN). 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.

Servers 40