Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. Poor performance has a compound effect on user expectations at an ecosystem level. Live by the link, die by the link.

Performance 124

Performance Network Cache Metrics 124

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Performance

OCTOBER 14, 2020

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. Substitution/unnesting. Figure 4: Execution plan for Query 4.

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

Brendan Gregg

FEBRUARY 28, 2023

At USENIX SREcon22 APAC I gave the opening keynote on the future of computer performance, rounding up the latest developments and making predictions of where I see things heading. This talk originated from my updates to Systems Performance 2nd Edition , and this was the first time I've given this talk in person!

Performance 52

Performance Latency Cache Virtualization 52

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. Ryan Stonecipher – Principle SQL Server Software Engineer. SQL Server.

Hardware 40

Hardware Cache Servers Software Engineering 40

Brendan Gregg

JULY 4, 2021

It's an exciting time for developments in computer performance, not just for the BPF technology (which I often [write about]) but also for processors with 3D stacking and cloud vendor CPUs (e.g., This was a chance to talk about other things I've been working on, such as the present and future of hardware performance.

Performance 52

Performance Latency Hardware Storage 52

Scalegrid

JANUARY 19, 2024

Recovering from a MongoDB rollback involves locating rollback files, using mongorestore to load data into a separate server, cleansing unneeded data, and importing the data back into the primary cluster, coupled with ongoing monitoring and maintenance of replica sets to maintain system health.

Database 130

Database Network Servers Monitoring 130

SQL Performance

JULY 24, 2022

SQL Server 2012 went out of all forms of official support about two weeks ago, on July 12 th. Best approaches for running totals – updated for SQL Server 2012. In the very first post on this site, I compared the performance of long-standing running totals methods with the new windowing functions added in SQL Server 2012.

Servers 66

Servers Strategy Availability Processing 66

SQL Performance

FEBRUARY 1, 2022

This is done to make managing operations in the transaction log easier for the log manager in SQL Server. You can’t specify how many VLFs are created by SQL Server when the database is first created or the log file automatically grows, but you can influence it. So why does SQL Server pick 37 and not 1 for the first VLF sequence number?

Architecture 53

Architecture Servers Virtualization Database 53

Alex Podelko

OCTOBER 18, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. While agile development / DevOps become mainstream nowadays, their integration with performance testing is just making first steps.

Performance Testing 100

Performance Testing Testing Performance DevOps 100

Dynatrace

MARCH 24, 2023

Originally developed as a research project at the University of California, Berkeley, in 2009, Mesos launched formally as a mature product in 2016 under the auspices of the Apache Software Foundation, a decentralized open source community. Dynatrace provides AI-powered observability into Kubernetes and Docker Swarm.

Infrastructure 185

Infrastructure Open Source Operating System Cloud 185

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

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. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. Background. The Query Optimizer.

Servers 75

Servers Engineering Efficiency Retail 75

SQL Performance

SEPTEMBER 25, 2019

Performance spools are lazy spools added by the optimizer to reduce the estimated cost of the inner side of nested loops joins. An example plan shape showing a lazy table performance spool is below: The questions I set out to answer in this article are why, how, and when the query optimizer introduces each type of performance spool.

Performance 104

Performance Cache Servers Education 104

Alex Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Cloud seriously impacts system architectures that has a lot of performance-related consequences. – Cloud. – Agile.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

SQL Performance

NOVEMBER 1, 2019

As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features.

Servers 40

Servers Hardware Database Availability 40

SQL Performance

JUNE 5, 2019

One of the more perplexing problems to troubleshoot in SQL Server can be those related to memory grants. Some queries need more memory than others to execute, based on what operations need to be performed (e.g. EXEC [ Sales ] [ usp_OrderInfo_OrderDate ] '2016-01-01' , '2016-06-30' ; GO. sort, hash).

Servers 41

Servers Cache Database Metrics 41

Alex Podelko

OCTOBER 28, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Sometimes it even lead to conclusions like “performance testing hitting the wall” just because load generation may be a challenge.

Performance Testing 100

Performance Testing Technology Technology Testing 100

SQL Server According to Bob

DECEMBER 26, 2017

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Q uick XE Trace ’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release. Here is an example using the SQL Server SSMS 2017 against my SQL 2016 server.

Servers 40

Servers Software Engineering Engineering Availability 40

Rigor

JANUARY 13, 2020

Reading time 1 min Why share the library of the web performance books while there’s a substantial collection of fantastic websites and articles on the net? High Performance Browser Networking. This book is about performance problems and the various technologies created to fight them. High Performance Websites.

Performance 75

Performance Social Media Website Website Performance 75

SQL Performance

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. This article explores the batch data normalized representation, explains why not all eight-byte data types can fit within 64 bits, and shows an example of how all this affects batch-mode performance. s = SUM ( T.

Performance 81

Performance C++ Storage Servers 81

Alex Russell

MAY 9, 2022

Despite advances in browser tooling , automated evaluation , lab tools , guidance , and runtimes , however, teams struggle to deliver even decent performance with today's popular frameworks. What is Performance? It may seem a silly question, but what is performance, exactly?

Performance 86

Performance Latency Metrics Engineering 86

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

SQL Performance

JULY 27, 2021

Continuing my series of articles on latches, this time I’m going to discuss the DBCC_OBJECT_METADATA latch and show how it can be a major bottleneck for consistency checks prior to SQL Server 2016 under certain circumstances. But remember, this bottleneck only happens for versions of SQL Server earlier than SQL Server 2016.

C++ 54

C++ Servers Database Code 54

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 82

Programming Servers Database Hardware 82

SQL Performance

MARCH 20, 2020

We're mid-cycle between releases, where we're not yet hearing about any of the features planned for SQL Server vNext. In SQL Server 2016, STRING_SPLIT solved a long-missing gap in a language that, admittedly, was not intended for complicated string processing. And that is what I want to bring up today. Can't filter duplicates.

Database 109

Database Servers C++ AWS 109

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 40

SQL Performance

OCTOBER 14, 2020

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. Substitution/unnesting. Figure 4: Execution plan for Query 4.

C++ 52

C++ Servers Code Efficiency 52

Dynatrace

JUNE 7, 2019

We continue to grow our public synthetic monitoring locations, but customers using Dynatrace Synthetic still need to monitor the performance and availability of internal web applications. Now, you’ll be able to: Measure internal web page performance and availability with single-URL monitors. ActiveGate OS: Ubuntu Server 16.04

Network 156

Network Monitoring Servers Hardware 156

Percona

FEBRUARY 2, 2023

The only real limitation is that one can only publish tables from a read-write server such as the PRIMARY. Instead, failing over is, in fact, not a single action but a collection of discrete steps that must be performed in an exact and precise manner. DML operations, such as INSERT, UPDATE, DELETE, TRUNCATE, etc., So there you have it.

Games 87

Games Open Source Tuning Speed 87

Dynatrace

AUGUST 10, 2019

Having the ability to monitor the performance and availability of your organization’s internal applications—in addition to your organization’s customer-facing applications—from within your corporate network is an important benefit of synthetic monitoring. Windows 2016 Server (or a supported Linux distribution ).

Monitoring 103

Monitoring Hardware Tuning Mobile 103

KeyCDN

MARCH 10, 2021

It's our mission to continuously improve web performance and each POP contributes to it. With Tel Aviv being the technology capital of Israel, it's the ideal edge server location. Performance report Brisbane - Australia Brisbane is our 4th POP in Australia. The new POP ensures better performance along the East Coast.

Latency 110

Latency Internet Internet Tuning 110

SQL Shack

MARCH 4, 2021

Introduction Sometimes, query tuning operations can get very challenging and complicated in SQL Server. With the SQL Server 2016, a new feature Query Store has been introduced and this feature […].

Tuning 71

Tuning Servers Performance 71

Rigor

SEPTEMBER 11, 2019

Reading time 16 min Whether you’re a web performance expert, an evangelist for the culture of performance, a web engineer incorporating performance into your process, or someone new to the web performance entirely, you probably identify as curious, excited about new ideas, and always learning. Rick Byers.

Performance 89

Performance Education Google Website 89

Dynatrace

OCTOBER 28, 2021

As software performance degrades or fails, the chaos engineers’ findings enable developers to add resiliency into the code, so the application remains intact in an emergency. Chaos engineering matured at organizations such as Netflix, and gave rise to technologies such as Gremlin (2016) , becoming more targeted and knowledge-based.

Engineering 225

Engineering Entertainment Cloud Infrastructure 225

Percona

SEPTEMBER 19, 2023

29 will let you set up redo log directory while performing a backup. This issue most often occurs when there is significant MySQL server activity during the backup operation, and the redo log file storage media operates faster than the backup storage media. Copyright (c) 2016, 2023, Oracle and/or its affiliates.

C++ 102

C++ Servers Storage Speed 102