SQL Performance

NOVEMBER 18, 2019

IT professionals are familiar with scoping the size of VMs with regards to vCPU, memory, and storage capacity. Compute optimized – High CPU-to-memory ration, medium traffic web servers and application servers. Storage optimized – High disk throughput and IO. Premium storage support. VM Types and Sizes. VM Image Options.

Azure 76

Azure Benchmarking Storage Virtualization 76

Percona

JUNE 22, 2023

Load balancing : Traffic is distributed across multiple servers to prevent any one component from becoming overloaded. Load balancers can detect when a component is not responding and put traffic redirection in motion. Here are the early steps: Perform analysis : A good place to start might be to conduct a Failure Mode Analysis (FMA).

Availability 110

Availability Database Open Source Hardware 110

The Netflix TechBlog

NOVEMBER 22, 2019

Netflix shares how Amazon EC2 Auto Scaling allows its infrastructure to automatically adapt to changing traffic patterns in order to keep its audience entertained and its costs on target. In this talk, we share how Netflix deploys systems to meet its demands, Ceph’s design for high availability, and results from our benchmarking.

AWS 37

AWS Entertainment Open Source Benchmarking 37

Percona

SEPTEMBER 1, 2023

Inadequate CPU, memory, or storage can lead to bottlenecks and performance degradation, so remedying these issues involves upgrading hardware or optimizing resource utilization through query and server configuration adjustments. Query plan analysis can also provide valuable insights. This does not apply to read (SELECT) traffic.

Tuning 52

Tuning Database Performance Hardware 52

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Using a global ASP as a benchmark can further mislead thanks to the distorting effect of ultra-high-end prices rising while shipment volumes stagnate. The Moto G4 , for example.

Performance 124

Performance Network Cache Metrics 124

Alex Russell

OCTOBER 22, 2017

Budgets are scaled to a benchmark network & device. Deciding what benchmark to use for a performance budget is crucial. Contended, over-subscribed cells can make “fast” networks brutally slow, transport variance can make TCP much less efficient , and the bursty nature of web traffic works against us.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

JANUARY 11, 2021

CrUX generates an overview of performance distributions over time, with traffic collected from Google Chrome users. But account for the different types and usage behaviors of your customers (which Tobias Baldauf called cadence and cohorts ), along with bot traffic and seasonality effects. You can create your own on Chrome UX Dashboard.

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

Treo Sites provides competitive analysis based on real-world data. For Mac OS, we can use Network Link Conditioner , for Windows Windows Traffic Shaper , for Linux netem , and for FreeBSD dummynet. Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. Large preview ). Large preview ).

Performance 145

Performance Cache Network Metrics 145