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. Poor performance has a compound effect on user expectations at an ecosystem level. Live by the link, die by the link.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

MAY 16, 2019

Achieving minimal logging using INSERT.SELECT into an empty clustered index target is not quite as simple as described in the Data Performance Loading Guide. The Data Loading Performance Guide contains a high-level summary of the conditions required for minimal logging into clustered tables: This post is concerned with the top row only.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

SQL Performance

APRIL 8, 2019

The L3 cache size is 64MB. The AMD EPYC 7551 processor has slightly lower single-threaded CPU performance when compared to the older 2.3 Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The L3 cache size is 64MB. lanes for I/O connectivity. They also only have 40 PCIe 3.0

Azure 42

Azure Virtualization Storage Benchmarking 42

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. With our focused investment in performance and scale, simply upgrading to SQL 2016 could bring 25% performance improvement. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Alex Russell

APRIL 29, 2021

Classics of the genre include: Apple's just focused on performance! The Performance Argument. 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. Steve & Tim's Close-up Magic.

Media 145

Media Games Education Engineering 145