article thumbnail

5.5 mm in 1.25 nanoseconds

Randon ASCII

In 2004 I was working for Microsoft in the Xbox group, and a new console was being created. Back in the day I wrote a lot of benchmarks in order to look for places where the actual performance of the CPU didn’t match what we expected. I wrote a lot of benchmarks. One benchmark I wrote measured the L2 cache latency.

Cache 126
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