article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support?

Servers 40
article thumbnail

Welcome to the Jungle

Sutter's Mill

From 1975 to 2005, our industry accomplished a phenomenal mission: In 30 years, we put a personal computer on every desk, in every home, and in every pocket. In 2005, however, mainstream computing hit a wall. The free lunch is over. Now welcome to the hardware jungle. iPad 2, Playbook, Kindle Fire, Nook Tablet) and smartphones (e.g.,

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

The Surprising Effectiveness of Non-Overlapping, Sensitivity-Based Performance Models

John McCalpin

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).

article thumbnail

Linux Load Averages: Solving the Mystery

Brendan Gregg

Nowadays, the source code to old operating systems can also be found online. Linux is also hard coding the 1, 5, and 15 minute constants. This state is used by code paths that want to avoid interruptions by signals, which includes tasks blocked on disk I/O and some locks. Why, exactly, did Linux do this?

Latency 111
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

This effort resulted in: · Changes to the SQL Server Engine · Changes to the SQL Server Linux Host Extension · Validation with the Windows Storage team · Validation with Windows Hyper-V team · Validation with Windows Azure Storage team · Conversations with Red Hat, HP, SUSE and Intel · Changes in the Linux file system. O_NONBLOCK.

Servers 90