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

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

SQL Server According to Bob

The operating system signals completion when the I/O stack finishes the request. Linux provides different system calls (syscall)/commands for asynchronous behavior. CSA ISO/IEC 9945-1:2005 (R2009) 3.375 Synchronized I/O Data Integrity Completion. You can explore your system using the df and lsblk commands.

Servers 90
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

Welcome to the Jungle

Sutter's Mill

Now welcome to the hardware jungle. 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. Galaxy S II, Droid X2, iPhone 4S). There’s no going back.

article thumbnail

Linux Load Averages: Solving the Mystery

Brendan Gregg

Nowadays, the source code to old operating systems can also be found online. For everyone familiar with other operating systems and their CPU load averages, including this state is at first deeply confusing. **Why?** The oldest change in the entire Linux repo dates back to 2005, when Linus imported Linux 2.6.12-rc2,

Latency 111