SQL Performance

JUNE 8, 2022

Let’s now continue following the compilation process noting the effects on simple parameterization as we go. 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. Let’s look at the plan cache: SELECT.

Cache 54

Cache Servers Database Processing 54

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

The Compilation Process. 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. It’s simply too early in the process. Let’s look at the plan cache: SELECT. usecounts , CP. objtype , ST. [

Cache 55

Cache Database Servers Testing 55

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. End of Part 3.

Cache 58

Cache Servers Database Testing 58

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? How Do You Use KeyCDN WebP Caching?

Website 72

Website Speed Cache Google 72

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. Process Summary. [ 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

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. Efficient data processing and indexing, making it optimal for executing queries and handling large datasets.

Open Source 52

Open Source Servers Storage Scalability 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. Advances in browser content processing. The fastest Androids predictably remain 18-24 months behind, owing to cheapskate choices about cache sizing by Qualcomm, Samsung Semi, and all the rest.

Performance 124

Performance Network Cache Metrics 124

All Things Distributed

APRIL 27, 2011

The Amazon.com 2010 Shareholder Letter Focusses on Technology. In the 2010 Shareholder Letter Jeff Bezos writes about the unique technologies developed at Amazon.com over the years. Technology infuses all of our teams, all of our processes, our decision-making, and our approach to innovation in each of our businesses.

Technology 151

Technology Technology AWS Storage 151

All Things Distributed

AUGUST 17, 2011

But while this blog happily runs out of S3, the process of creating and updating the content still required a server to run my Moveable Type installation and hold the database. My templates and blog posts are now located in DropBox and thus locally cached at each machine I use. APAC Summer Tour.

Servers 126

Servers Social Media AWS Website 126