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

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

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

SQL Performance

OCTOBER 29, 2019

CustomerID , c. Customers c JOIN Sales. CustomerTransactions ct ON c. GROUP BY c. CustomerID , c. ORDER BY ExecutionCount DESC ; Note: The sys.dm_exec_function_stats DMV was added in SQL Server 2016. AccountOpenedDate , COUNT ( ct. CustomerTransactionID ) FROM Sales. CustomerID = ct. CustomerID.

C++ 74

C++ Database Servers Tuning 74

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

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.

Performance 75

Performance Social Media Website Website Performance 75

Percona

JANUARY 17, 2019

select SQL_CALC_FOUND_ROWS FlightDate, UniqueCarrier, TailNum, FlightNum, Origin, OriginCityName, Dest, DestCityName, DepDelay, ArrDelay FROM ontime_ind o JOIN carriers c on o.carrier = c.carrier_code WHERE (carrier_name like 'United%' or carrier_name like 'Delta%') and ArrDelay > 30 ORDER by DepDelay DESC LIMIT 10G.

Cache 46

Cache C++ AWS Airlines 46