Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 103

Performance Latency Cache Virtualization 103

SQL Performance

MARCH 29, 2022

Simple parameterization has a number of quirks in this area, which can result in more parameterized plans being cached than expected, or finding different results compared with the unparameterized version. When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter.

Cache 90

Cache Servers Database Testing 90

SQL Performance

MARCH 30, 2021

This five-part series takes a deep dive into the way SQL Server row mode parallel plans start up. The desired plan shape can also be obtained against the smaller Stack Overflow 2010 data set if that is more convenient. See Myth: SQL Server Caches a Serial Plan with every Parallel Plan for details. MonthlyPosts AS. (

Cache 98

Cache Servers Processing Operating System 98

Smashing Magazine

OCTOBER 29, 2019

Google developed WebP back in 2010 after acquiring a company called On2 Technologies. It’ll handle the conversion, but it won’t help you modify your origin server so that it knows when to deliver WebPs and when to deliver a traditional image format to visitors. What Is WebP Caching? What is WebP? Source: KeyCDN ).

Website 75

Website Speed Cache Google 75

SQL Performance

MARCH 22, 2022

In this first part, after a quick introduction, I look at the effects of simple parameterization on the plan cache. It's almost always better to explicitly parameterize statements, rather than relying on the server to do it. The aim is to reduce compilations by increasing cached plan reuse. Simple Parameterization. Shell Plans.

Cache 61

Cache Servers Database Code 61

John McCalpin

FEBRUARY 17, 2025

The Multicore Era Over the past ~15 years, server processors from Intel and AMD have evolved from the early quad-core processors to the current monsters with over 50 cores per socket. GB/s peak DRAM bandwidth, requiring 6 concurrent 64-byte cache line accesses to be pending at all times to maintain full bandwidth.

Latency 40

Latency Hardware Cache Systems 40

SQL Performance

APRIL 18, 2022

It’s no surprise even highly experienced SQL Server users tend to get this wrong, given the contradictory information often supplied to us. Let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14, with database compatibility set to 150. It’s important to remember the plan must be cached.

Cache 58

Cache Servers Database Testing 58

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. The fastest Androids predictably remain 18-24 months behind, owing to cheapskate choices about cache sizing by Qualcomm, Samsung Semi, and all the rest. The Moto G4 , for example.

Performance 127

Performance Network Mobile Metrics 127

SQL Performance

JUNE 8, 2022

When the parser allows simple parameterization to continue, SQL Server® increments the Auto-Param Attempts/sec counter of the SQL Statistics object. As in previous parts, code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo.

Cache 54

Cache Servers Database Processing 54

SQL Performance

MAY 20, 2022

The most important things to understand about server-side parameterization are it doesn’t happen all at once and a final decision to parameterize isn’t made until the end of the process. Imagine someone handing you a query written for an unknown SQL Server database and asking you to identify parameterizable constants. usecounts , CP.

Cache 55

Cache Database Servers Testing 55

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 52

Performance Latency Cache Virtualization 52

KeyCDN

OCTOBER 24, 2018

With Helsinki being the capital and most populous municipality of Finland, it makes for a great edge server location. However, now with the Helsinki edge server in production, this helps further close the gap between visitors who live in Finland and the nearest KeyCDN POP they have access to.

Internet 48

Internet Internet Speed Network 48

SQL Performance

AUGUST 4, 2022

To recap: Normalization and decoding promote cached plan reuse. Let’s now continue following the compilation process to see how SQL Server decides if simple parameterization is safe or unsafe. The CBO has significant start-up and runtime costs and may consume significant server resources. Generating a Trivial Plan.

Servers 61

Servers Cache Database Availability 61

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52