Remove 2004 Remove Benchmarking Remove Efficiency Remove Hardware
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

KB ​​ boundaries efficiently. ​​ Although ​​ SQL Server ​​ tries ​​ to use the log space as efficiently as possible, ​​ certain application patterns cause the log-block fill percentages to remain small. ​​ This creates 8?KB

Servers 40