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

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

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

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

All Things Distributed

OCTOBER 2, 2017

We were pushing the limits of what was a leading commercial database at the time and were unable to sustain the availability, scalability and performance needs that our growing Amazon business demanded. Performant – The service would need to be able to maintain consistent performance in the face of diverse customer workloads.

Internet 130

Internet Internet AWS Performance 130

Dynatrace

NOVEMBER 16, 2021

The dashboard was built during my recent Performance Clinic on k8s monitoring at Scale with Prometheus and Dynatrace. Since its launch in 2012, Prometheus has become the standard technology to collect metrics in a Kubernetes cluster. Here we’ll explore how to collect Prometheus metrics and what you can achieve with them.

Metrics 206

Metrics Infrastructure Open Source Database 206

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

Dynatrace

APRIL 2, 2020

Performance has always mattered. With sniffers, network performance engineers were ultimately able to relate wire data performance to what business owners expected from the networks they financed. The network performance engineer who managed the sniffer was the guru. The DC RUM wave. Technology developments come in waves.

Network 166

Network Traffic Monitoring Java 166

SQL Server According to Bob

JUNE 6, 2016

As indicated, SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance. This post will outline SQL Server’s decisions around SSE/AVX or software algorithm use. SQL Server asks the CPU if it supports SSE or AVX in order to determine the level of hardware support present on the system.

Servers 40

Servers Hardware Software Engineering Software 40

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

Tim Kadlec

JUNE 21, 2022

HTTP/3 work started in 2012 with Google working on QUIC, adopted by IETF in 2017, RFC’s published in June 2022. No server push! The RSVP problem: HTTP/3 might be blocked on the network or may not be enabled on the server. So the browser will only try HTTP/3 if it’s certain the server supports it. What and Why?

Network 64

Network Mobile Google Cache 64

SQL Performance

MARCH 15, 2021

This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects are also deprecated.

Servers 64

Servers Azure Best Practices Monitoring 64

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

The Morning Paper

FEBRUARY 11, 2020

This paper tells the story of Let’s Encrypt, from it’s early beginnings in 2012/13 all the way to becoming the world’s largest HTTPS Certificate Authority (CA) today – accounting for more currently valid certificates than all other browser-trusted CAs combined. CCS’19. In the beginnning. The last word.

Internet 119

Internet Internet Open Source Transportation 119

SQL Server According to Bob

JUNE 22, 2016

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Trace flag –T8048 longer exists in SQL Server 2016.

Servers 40

Servers Azure Software Engineering Design 40

SQL Performance

MAY 1, 2019

This is reflected in the summary tables included in the Data Loading Performance Guide and the Tiger Team post. The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking.

Servers 47

Servers Database Testing Performance 47

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT.

C++ 111

C++ Database Servers Code 111

SQL Performance

JULY 11, 2019

Connecting to SQL Server 2012 or better, or Azure SQL Database. And recommended system configuration: Two or more cores 8GB or more of memory Operating Systems: Windows (8.1 / Server 2012 R2 or better) macOS (10.13 In a new query window, establish a connection to a server, and write or paste a query. or better).

Azure 90

Azure Servers Tuning Operating System 90

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). 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. Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

All Things Distributed

AUGUST 17, 2012

By Werner Vogels on 17 August 2012 07:00 PM. I am in São Paolo, Brazil for the 2012 AWS Latin America Summit and for The Next Web Latin America conference. Matt Welsh s thesis work at Berkeley was on building high-performance internet services. Werner Vogels weblog on building scalable and robust distributed systems.

Architecture 98

Architecture AWS Internet Internet 98

SQL Performance

FEBRUARY 22, 2021

I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us. The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests , sys.dm_exec_sessions , and sys.dm_exec_connections.

Latency 57

Latency Servers Monitoring Systems 57

Smashing Magazine

NOVEMBER 8, 2018

Sharing Data Among Multiple Servers Through AWS S3. Sharing Data Among Multiple Servers Through AWS S3. After the file is uploaded to a server on step 1, the file must be available to whichever server handles the request for steps 2 and 3, which may or may not be the same one for step 1. Leonardo Losoviz.

AWS 44

AWS Servers Storage Cloud 44

All Things Distributed

MAY 8, 2012

By Werner Vogels on 08 May 2012 02:00 PM. Amazon RDS for SQL Server. Amazon RDS manages all these time consuming database administration tasks including patch management, striping the storage for better performance, and database and log backups for disaster recovery, enabling developers to focus more on their applications.

Cloud 116

Cloud Development AWS Servers 116

SQL Performance

APRIL 18, 2022

It’s no surprise even highly experienced SQL Server users tend to get this wrong, given the contradictory information often supplied to us. Let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14, with database compatibility set to 150. Parameterization Not Attempted. DisplayName , LOWER ( U.

Cache 58

Cache Servers Database Testing 58

SQL Performance

MARCH 22, 2022

Both target performance and efficiency for workloads frequently submitting simple statements. It's almost always better to explicitly parameterize statements, rather than relying on the server to do it. In any event, it would be an unusual workload that does not contain at least some parameterized statements server-side.

Cache 61

Cache Servers Database Code 61

SQL Performance

MAY 20, 2022

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. Imagine someone handing you a query written for an unknown SQL Server database and asking you to identify parameterizable constants.

Cache 55

Cache Database Servers Testing 55

All Things Distributed

NOVEMBER 13, 2018

In 2012, Amazon opened its first Italian office and its first Italian point of presence (PoP) based in Milan. Lamborghini, the world-famous manufacturer of elite, luxury sports cars based in Italy, has been using AWS to reduce the cost of their infrastructure by 50 percent, while also achieving better performance and scalability.

AWS 167

AWS Energy Automotive Traffic 167

SQL Performance

SEPTEMBER 2, 2021

UPDATE: September 2nd, 2021 (Originally published July 26th, 2012.). SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1. STRING_SPLIT() in SQL Server 2016 : Follow-Up #2.

C++ 59

C++ Servers Testing Database 59

John McCalpin

JANUARY 9, 2019

This week I updated three of those posts — two really old ones (primarily of interest to computer architecture historians), and one from 2018: July 2012: Local and Remote Memory Latency on AMD Processors in 2-socket and 4-socket servers. December 2013: Notes on Memory Bandwidth on the Xeon Phi (Knights Corner) Coprocessor.

Latency 40

Latency Architecture Servers Performance 40

SQL Server According to Bob

JULY 12, 2016

Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements. For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. This is behavior is unchanged in SQL Server 2016.

Servers 40

Servers Design Engineering Database 40

SQL Performance

AUGUST 15, 2019

Connecting to SQL Server 2012 or better, or Azure SQL Database. And recommended system configuration: Two or more cores 8GB or more of memory Operating Systems: Windows (8.1 / Server 2012 R2 or better) macOS (10.13 In a new query window, establish a connection to a server, and write or paste a query. or better).

Azure 50

Azure Servers Tuning Operating System 50

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. Depending on an organization’s specific requirements, legal or otherwise, full backups are typically performed periodically, such as daily, weekly, or monthly.

Storage 67

Storage Strategy Network Efficiency 67

All Things Distributed

MAY 13, 2012

By Werner Vogels on 14 May 2012 12:01 AM. The first set of features that CloudFront is launching today include: Multiple Origin Servers: the ability to specify multiple origin servers, including a default origin, for a CloudFront download distribution. This helps improve performance even further. All Things Distributed.

Cache 118

Cache Latency AWS Website 118

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. set nocount on.

Hardware 40

Hardware Cache Servers Software Engineering 40

All Things Distributed

SEPTEMBER 25, 2012

By Werner Vogels on 25 September 2012 06:00 PM. Following the huge success of being able to provision a consistent, user-requested I/O rate for DynamoDB and Elastic Block Store (EBS), the AWS Database Services team has now released Provisioned IOPS, a new high performance storage option for the Amazon Relational Database Service (Amazon RDS).

Cloud 118

Cloud AWS Storage Database 118

SQL Performance

APRIL 23, 2019

In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate. SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. Introduction. instructions are available.

Servers 67

Servers Testing Metrics Storage 67

Tim Kadlec

DECEMBER 29, 2015

If your client-side MVC framework does not support server-side rendering, that is a bug. It cripples performance, limits reach and reduces stability. Choosing Performance. Performance is a decision. 2012 Favorites. Client-side MVC’s Major Bug. Taking Let’s Encrypt for a Spin. AMP and Incentives.

Energy 40

Energy Google Servers Processing 40