SQL Server Performance

NOVEMBER 10, 2017

Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance.

Tuning 40

Tuning Performance Servers Database 40

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at [Kernel Recipes] in 2017 and have shared the full story here. ## 1. I have been surprised many times by unexpected performance issues, so I thought I should check their instances anyway. The default size is 128 Kbytes, and people shouldn't be tuning below 8 Kbytes.

Cache 141

Cache Cloud Code Java 141

Speed Curve

DECEMBER 25, 2013

The following article was originally published in the 2013 Performance Calendar. There's 31 great articles to explore in the calendar including Steve Souders's browser wishlist and Tim Kadlec's take on what it takes to create a performance culture. -. Case study: the new responsive Guardian site. Source: SpeedCurve.

Performance 60

Performance Mobile Website Benchmarking 60

Scalegrid

AUGUST 27, 2024

Key features of RabbitMQ, such as message acknowledgments, complex routing, and asynchronous processing, contribute to system reliability and performance. Use cases for RabbitMQ encompass areas like order processing in eCommerce, real-time notifications, and multiplayer gaming, showcasing its adaptability to different operational needs.

Ecommerce 130

Ecommerce IoT Games Scalability 130

Brendan Gregg

OCTOBER 8, 2018

Observability is one of many other use cases, as is [eXpress Data Path], [container security and networking], [iptables], [infrared decoding], [intrusion detection], [hyperupcalls], and [FUSE performance]. It's been an interesting case study of Linux vs commercial development. It's hard to overstate how important this is.

C++ 105

C++ Virtualization Programming Latency 105

O'Reilly

FEBRUARY 18, 2025

A Case Study in Misleading AI Advice An example of this disconnect in action comes from an interview with Jake Heller, CEO of Casetext. Like a student who was given the answers before an exam, the model will look good on paper but be unlikely to perform well in the real world. Youve come to the right place!

Latency 62

Latency Tuning Metrics Testing 62

Rigor

SEPTEMBER 3, 2019

Case studies abound. There are many tools available that can help you monitor, manage, and optimize your website and application performance: APM, synthetics, RUM, alerting, alert integrations, and more. How are you monitoring end-user performance today? Rigor’s free performance report.

Website 74

Website Cache Traffic Ecommerce 74

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at Kernel Recipes in 2017; it is an old story that's worth resharing here. I have been surprised many times by unexpected performance issues, so I thought I should check their instances anyway. The default size is 128 Kbytes, and people shouldn't be tuning below 8 Kbytes.

Cache 52

Cache Cloud Java Tuning 52

SQL Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Maximise compute performance with Azure SQL Data Warehouse – More JRJ on Azure DW.

Engineering 40

Engineering Azure Best Practices Servers 40

Brendan Gregg

SEPTEMBER 5, 2021

I summarized this case study at [Kernel Recipes] in 2017; it is an old story that's worth resharing here. ## 1. I have been surprised many times by unexpected performance issues, so I thought I should check their instances anyway. The default size is 128 Kbytes, and people shouldn't be tuning below 8 Kbytes.

Cache 40

Cache Cloud Code Java 40

O'Reilly

FEBRUARY 25, 2025

Thus, this post serves as a case study on adding generative AI into a personal project where I didnt have much time, resources, or expertise at my disposal. There were a million little details to work through, but thats the case with any nontrivial software project. For me it seems like Llama 3.3

Code 57

Code Programming Servers Cloud 57

Brendan Gregg

OCTOBER 7, 2018

Observability is one of many other use cases, as is [eXpress Data Path], [container security and networking], [iptables], [infrared decoding], [intrusion detection], [hyperupcalls], and [FUSE performance]. It's been an interesting case study of Linux vs commercial development. It's hard to overstate how important this is.

C++ 40

C++ Virtualization Programming Latency 40

The Netflix TechBlog

NOVEMBER 9, 2020

Case Study: Studio Edge Intro to Studio Ecosystem Netflix is producing original content at an accelerated pace. Materialized views had performance benefits, but data consistency lagged by varying degrees. A note on performance: Query Planning and Execution adds a ~10ms overhead in the worst case.

Architecture 360

Architecture Engineering Scalability Open Source 360

Percona

MARCH 7, 2019

In this blog post, I want to share a case we worked on a few days ago. I’ll show you how we approached the resolution of a MySQL performance issue and used Percona Monitoring and Management PMM to support troubleshooting. There could be more, but this particular query was definitely hurting the performance of the server.

C++ 108

C++ Traffic Servers Monitoring 108

The Netflix TechBlog

FEBRUARY 13, 2024

Netflix also performs canary tests — software A/B tests between current and newer software versions. The purpose of a canary test is twofold: to act as a quality-control gate that catches bugs prior to full release, and to measure performance of the new software in the wild.

Testing 244

Testing Software Software Metrics 244

Brendan Gregg

OCTOBER 28, 2024

I was lucky to have Dr. Matthew (Ben) Olson , an Intel AI engineer who has also worked on eBPF performance tooling ( processwatch ) as well as memory management research, join my team and do most of the development work. Note that the samples are EU stall-based, which means theoretical performance wins can take the percentages down to zero.

Programming 130

Programming Hardware Tuning C++ 130

Smashing Magazine

MARCH 19, 2021

Working around improving performance was an ongoing journey on SmashingMag for a while. In the end of last year we’ve noticed that we’ve seen quite a drop in performance in 2020, so we rolled up our sleeves and got to work. We were busy not only with performance and UX optimizations though. Web Performance. Thank you! ??.

Mobile 142

Mobile Design Cache Code 142