Brendan Gregg

FEBRUARY 28, 2023

I didn't end up getting published in SysAdmin directly, but my performance work did make it as a feature article (thanks Matty).

Performance 103

Performance Latency Cache Virtualization 103

Dotcom-Montior

AUGUST 5, 2020

Page speed has been a key factor in Google’s ranking algorithm since 2010 , so it is essential to understand the various ways you can optimize your pages and why implementing synthetic monitoring can ensure your pages perform flawlessly and revenue isn’t lost. Browser Caching: Although it may seem commonplace, caching is sometimes overlooked.

Website 92

Website Speed Cache Traffic 92

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. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. DisplayName.

Cache 90

Cache Servers Database Testing 90

SQL Performance

MARCH 30, 2021

The desired plan shape can also be obtained against the smaller Stack Overflow 2010 data set if that is more convenient. Running a parallel plan on a single thread can also happen when a cached parallel plan is reused by a session that is limited to DOP 1 by an environmental setting (e.g. It can be downloaded at the same link.

Cache 98

Cache Servers Processing Operating System 98

All Things Distributed

AUGUST 17, 2011

My templates and blog posts are now located in DropBox and thus locally cached at each machine I use. The Amazon.com 2010 Shareholder Letter Focusses on Technology. There are a number of pages in the "categories" section that have not been regenerated as according to the website statistics not many of those were accessed.

Servers 109

Servers Social Media AWS Website 109

John McCalpin

FEBRUARY 17, 2025

In my previous post , I reviewed historical data on single-core/single-thread memory bandwidth in multicore processors from Intel and AMD from 2010 to the present. The increase in single-core memory bandwidth has been rather slow overall, with Intel processors only showing about a 2x increase over the 13 years from 2010 to 2023.

Latency 40

Latency Hardware Cache Systems 40

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. The aim is to reduce compilations by increasing cached plan reuse. Let’s look at an example, using the Stack Overflow 2010 database on SQL Server 2019 CU 14. Simple Parameterization. sp_configure. EXECUTE sys.

Cache 61

Cache Servers Database Code 61

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

APRIL 18, 2022

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. Requesting an estimated plan from SSMS does not cache the plan produced (since SQL Server 2012). Dynamic Management Objects.

Cache 58

Cache Servers Database Testing 58

SQL Performance

JUNE 8, 2022

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. The text will normalize to the same parameterized form , allowing a cached prepared plan to be matched and reused. Let’s look at the plan cache: SELECT.

Cache 54

Cache Servers Database Performance 54

John McCalpin

APRIL 25, 2023

For most high-end processors these values have remained in the range of 75% to 85% of the peak DRAM bandwidth of the system over the past 15-20 years — an amazing accomplishment given the increase in core count (with its associated cache coherence issues), number of DRAM channels, and ever-increasing pipelining of the DRAMs themselves.

Benchmarking 40

Benchmarking Cache Latency Tuning 40

Brendan Gregg

FEBRUARY 28, 2023

As for attending USENIX conferences: I finally started attending and speaking at them in 2010 when a community manager encouraged me to (thanks Deirdre Straughan), and since then I've met many friends and connections, including Amy who is now USENIX President, and Rikki with whom I co-chaired the USENIX LISA18 conference.

Performance 52

Performance Latency Cache Virtualization 52

SQL Performance

MAY 20, 2022

As in previous parts, most code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo. Let’s look at the plan cache: SELECT. The parameter data types are still different, so separate plans are cached and no plan reuse occurs.

Cache 55

Cache Database Servers Testing 55

KeyCDN

OCTOBER 24, 2018

As of 2010, Finland has become the first country in the world to make Internet access a legal right. The use of online bank services, online shopping, and travel service browsing have increased significantly since spring 2004.

Internet 48

Internet Internet Speed Network 48

SQL Performance

AUGUST 4, 2022

To recap: Normalization and decoding promote cached plan reuse. Code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo. [ This series: Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 ].

Servers 61

Servers Cache Database Availability 61

Percona

JUNE 4, 2023

MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. In 2008, Sun Microsystems acquired MySQL AB, and then, in 2010, Oracle bought Sun Microsystems. release based on MySQL 5.5, GA 28 April 2011 5.5.11-20.2

Open Source 52

Open Source Servers Storage Scalability 52

Smashing Magazine

OCTOBER 29, 2019

Google developed WebP back in 2010 after acquiring a company called On2 Technologies. That’s why it’s no surprise that it’s developed a built-in WebP caching and image processing solution that helps developers more easily deliver the right file formats to visitors. What Is WebP Caching? KeyCDN WebP caching handles all of it.

Website 75

Website Speed Cache Google 75