Brendan Gregg

JULY 2, 2021

cachestat File system cache statistics line charts. I chose these to find the most performance wins with the fewest tools. For a more recent example, I wrote cachestat(8) while on vacation in 2014 for use on the Netflix cloud, which was a mix of Linux 3.2 execsnoop New processes (via exec(2)) table. at the time.

Latency 145

Latency Cache Energy Systems 145

Speed Curve

JUNE 14, 2021

I’m delighted to be joining some of my favourite web performance people at SpeedCurve! I’ve been a full-time web performance consultant for around nine years. I’ve written a couple of books , spoken at conferences , and become an organiser of London’s Web Performance Meetup.

Retail 52

Retail Internet Internet Education 52

SQL Performance

MAY 16, 2019

Achieving minimal logging using INSERT.SELECT into an empty clustered index target is not quite as simple as described in the Data Performance Loading Guide. The Data Loading Performance Guide contains a high-level summary of the conditions required for minimal logging into clustered tables: This post is concerned with the top row only.

Cache 67

Cache Servers Testing Storage 67

ACM Sigarch

MARCH 18, 2019

Existing systems can be studied with measurement, while prospective systems are most often studied by extrapolating from measurements of prior systems or via simulation software that mimics target system function and provides performance metrics. Can one both minimize latency and maximize throughput for unscheduled work? Answered in Part 2.).

Systems 60

Systems Latency Performance Analytics 60

Brendan Gregg

AUGUST 29, 2021

A service team was debugging a performance issue and noticed it coincided with a high rate of paging. I was asked to help, and used a variety of Linux performance tools to solve this including those that use eBPF and Ftrace. Reads usually have apps waiting on them; writes may not (write-back caching). This is "cache busting."

Cache 40

Cache C++ AWS Systems 40

Nick Desaulniers

JUNE 2, 2018

ccache , the compiler cache, is a fantastic way to speed up build times for C and C++ code that I previously recommended. Usually when this happens with ccache, there’s something non-deterministic about the builds that prevents cache hits. Cold Cache. kB max cache size 5.0 kB max cache size 5.0 Ubuntu SMP.

Speed 46

Speed Cache C++ Systems 46

ACM Sigarch

MARCH 25, 2019

For the previous cache miss buffer example, the 32-buffer answer is minimal for 100-ns average miss latency. He is a fellow of IEEE and the ACM, serves as Chair of the Computer Community Consortium (2018-20) and served as Wisconsin Computer Sciences Department Chair 2014-17. The M/M/1 design seems to over-designed by 2x (100ms ?

Systems 53

Systems Latency Performance C++ 53

SQL Performance

APRIL 8, 2019

The L3 cache size is 64MB. The AMD EPYC 7551 processor has slightly lower single-threaded CPU performance when compared to the older 2.3 The older Intel Xeon E5-26xx v3 (Haswell) series which was introduced in Q3 of 2014, had a maximum memory bandwidth of 2133MHz. The L3 cache size is 64MB. lanes for I/O connectivity.

Azure 42

Azure Virtualization Storage Benchmarking 42

Alex Russell

APRIL 29, 2021

Classics of the genre include: Apple's just focused on performance! The Performance Argument. As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. Steve & Tim's Close-up Magic.

Media 145

Media Games Education Engineering 145

The Morning Paper

JANUARY 23, 2020

Today we’ll be digging into the analysis of an incident that took place at Etsy on December 4th, 2014. With only an hour or so of degraded performance in the end, it’s not the worst incident you can imagine, but it was clearly taken as very serious given the time of year.

Internet 53

Internet Internet Cache Engineering 53

SQL Performance

JUNE 21, 2019

What I find is very similar to backups: No DBCC CHECKDBs performed at all DBCC CHECKDBs being performed only on select databases DBCC CHECKDBs last performed months or years ago. For SQL Server 2008R – 2014, you could lower this threshold using trace flag 2371. Worst case is a job scheduled reporting failed DBCC CHECKDBs.

Servers 49

Servers Azure Hardware Database 49

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. With our focused investment in performance and scale, simply upgrading to SQL 2016 could bring 25% performance improvement. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Server According to Bob

JUNE 3, 2016

. ‘It Just Runs Faster’ – Out of the box SQL Server 2016 DBCC provides you better performance, scale while shrinking your maintenance window(s.). The DBCC CheckDB demonstration loads a table and demonstrates the performance improvement. SQL Server 2014. Bob Dorr – Principal SQL Server Escalation Engineer.

Hardware 40

Hardware Cache Servers Software Engineering 40

Brendan Gregg

JULY 2, 2021

cachestat File system cache statistics line charts 7. I chose these to find the most performance wins with the fewest tools. As an extreme example, I wrote cachestat(8) while on vacation in 2014 for use on the Netflix cloud, which was a mix of Linux 3.2 execsnoop New processes (via exec(2)) table 2. It depends on the tool.

Open Source 40

Open Source Latency Cache Energy 40

SQL Performance

JULY 16, 2019

For many years, I explicitly advised people not to run their SQL Server workloads on AMD hardware because of the much lower single-threaded CPU performance and consequently higher SQL Server core license costs. This has led to a very noticeable reduction in generational performance increases since Broadwell-EP, as shown in Figure 1.

Servers 46

Servers Hardware Architecture Retail 46

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. GO. -- Clear the plan cache. GO. -- Clear the plan cache. GO. -- Clear the plan cache.

Cache 64

Cache Testing Servers Code 64

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. The SQL Server batch mode implementation of a Bloom filter is optimized for modern CPU cache architectures and is known internally as a complex bitmap. Background.

Servers 75

Servers Engineering Efficiency Retail 75

Percona

JUNE 4, 2023

Critical features of MariaDB include robust security features like encryption at rest and in transit, user authentication, and role-based access control (RBAC), as well as high-performance query execution, advanced indexing techniques, and replication, clustering, and sharding, ensuring scalability and high availability. What is MySQL?

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). This can make it difficult to draw sound performance-tuning conclusions.

Servers 95

Servers Tuning Architecture Processing 95

SQL Server According to Bob

DECEMBER 31, 2018

This was a project I created in 2014 to help Microsoft SQL Server support process incoming XEvent files, including the ability to merge XEvent files from multiple servers such as replication or high availability XEvent capture. ”); }. System.IO.Directory.Move(strFile, m_strLastOutputName); } m_strLastOutputName = String.Empty; } }.

Efficiency 40

Efficiency Code Servers Cache 40

Abhishek Tiwari

NOVEMBER 3, 2018

They often get blindsided by vendor’s pitch and end-up making decision based on some fancy demos (see my post from 2014 on Adobe AEM ). I am yet to find a traditional CMS vendor who can deliver this level of performance on the scale (millions of page views per day). Eventually, we decided to move them to Jekyll.

Systems 63

Systems Cache Website Network 63