SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). Our design needed to scale and be adaptable to the modern hardware on the market.

Availability 40

Availability Servers Hardware Benchmarking 40

CSS Wizardry

MARCH 3, 2019

If there is a newer file available on the server, we definitely want to download it. If, however, there wasn’t a new file on the server, we’ll bring back a 304 header, no new file, but an entire roundtrip of latency. We can completely cut out the overhead of a roundtrip of latency. What do we mean by a mutable or immutable file?

Cache 264

Cache Latency Strategy Servers 264

Alex Russell

DECEMBER 18, 2022

The talks are up on YouTube , including my own (behind a paywall, but the slides are freely available [1] ): The talk, like this post, is an update on network and CPU realities this series has documented since 2017. That is, what was the average device in 2016? 2023 Content Targets #. 2-4 CPU cores. 4GB RAM or less. Networks #.

Performance 113

Performance Network Mobile Latency 113

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. Modern network performance and availability. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively.

Performance 124

Performance Network Cache Metrics 124

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Individual processes generate WAL records, and latency is very crucial for transactions. They do a much better job than what was available in PostgreSQL (pglz).

Database 117

Database Benchmarking Open Source Latency 117

The Morning Paper

MAY 21, 2019

” This paper describes a “far memory” system that has been in production deployment at Google since 2016. This boils down to a single digit µs latency toleration in the tail for far memory, and in addition to security and privacy concerns, rules out remote memory solutions. Enter zswap! Evaluation.

Software 78

Software Software Google Hardware 78

Alex Russell

MAY 9, 2022

This is a complex topic, but to borrow from a recent post , web performance expands access to information and services by reducing latency and variance across interactions in a session, with a particular focus on the tail of the distribution (P75+). Consistent performance matters just as much as low average latency.

Performance 86

Performance Latency Metrics Engineering 86