SQL Server According to Bob

SEPTEMBER 26, 2016

While we were confident in the design of SQL Server 2012, several customers reported to us performance problems that did not appear to be with disk subsystems, CPU, or networks. Our design needed to scale and be adaptable to the modern hardware on the market. First, we looked at the overall architecture of the replica design.

Availability 40

Availability Servers Hardware Benchmarking 40

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. Such “torn pages” are corruptions from the database point of view. This is generally referred to as “ partial page writes ” or “ torn pages.”

Database 114

Database Benchmarking Open Source Latency 114

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. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

APRIL 8, 2019

Both of these Intel processors are special bespoke models that are not in the Intel ARK database. I wrote about using CPU-Z to benchmark the Intel Xeon E5-2673 v3 processor in an Azure VM in this article. The slightly newer Intel Xeon E5-26xx v4 (Broadwell) series which was introduced in Q1 of 2016, increased that to 2400MHz.

Azure 42

Azure Virtualization Storage Benchmarking 42

Alex Russell

APRIL 29, 2021

As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. With each team, benchmarks lost are understood as bugs. For example, an area where Apple is absolutely killing it is in mobile CPU design.

Media 145

Media Games Education Engineering 145

Alex Russell

MAY 9, 2022

Design: Performance is the gap between Figma mockups and the user experience of products for many, but not all , users. The extent to which a product performs well, the higher its likelihood of behaving in accordance to the approved design spec. miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016.

Performance 86

Performance Latency Metrics Engineering 86