SQL Performance

DECEMBER 9, 2020

L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.

C++ 114

C++ Servers Testing Processing 114

Brendan Gregg

OCTOBER 8, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. ply is also C, whereas bpftrace is C++. # Attaching 2 probes. ^C

C++ 110

C++ Virtualization Programming Latency 110

SQL Performance

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). CustomerID , c. Customers c JOIN Sales. CustomerTransactions ct ON c. GROUP BY c. CustomerID , c. Each option has pros and cons. CustomerID = ct.

C++ 74

C++ Database Servers Tuning 74

SQL Performance

DECEMBER 9, 2020

L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.

C++ 61

C++ Servers Testing Processing 61

Rigor

JANUARY 13, 2020

These are the bestsellers in the web performance field, including the good old Speed Up Your Site (2003) by Andy King; Steve Souders’ Even Faster Web Sites (2009) ; Ilya Grigorik’s High Performance Browser Networking (2013) ; Tammy Everts’ Time is Money (2016) ; and a handful of more recent publications. Responsive and Fast.

Performance 75

Performance Social Media Website Website Performance 75

Brendan Gregg

OCTOBER 7, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. ply is also C, whereas bpftrace is C++. # Attaching 2 probes. ^C

C++ 40

C++ Virtualization Programming Latency 40

Percona

JANUARY 17, 2019

I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, 84.1 | | version_comment | Percona Server (GPL), Release 84.1, AWS Aurora (based on MySQL 5.6) MySQL on ec2. MySQL on ec2.

Cache 46

Cache C++ AWS Airlines 46