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. Statistics. SQL Server Agent alerts. DBCC CHECKDB.

Servers 49

Servers Azure Hardware Database 49

SQL Performance

SEPTEMBER 6, 2022

Instead, the question I’ll address here is exactly how and when lock escalation is triggered. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. Testing environment. ALTER DATABASE Escalation SET.

Database 98

Database Storage Testing Servers 98

SQL Performance

OCTOBER 20, 2022

When SQL Server reads data under locking read committed isolation (the default for non-cloud offerings) and chooses row-level locking granularity, it normally only locks one row at a time. This is common when identifying rows to update (or delete) when a blocking operator appears in the execution plan. Lock Lifetimes.

Testing 91

Testing Servers Cache Engineering 91

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Test Environment. The cost threshold for parallelism is set to 50.

Servers 86

Servers Tuning Database Efficiency 86

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. What are the Benefits of MySQL Performance Tuning?

Tuning 52

Tuning Database Performance Hardware 52

SQL Performance

MAY 7, 2019

I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server. I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server.

Servers 40

Servers Azure Metrics Tuning 40

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

APRIL 8, 2021

This is the second part of a five-part series taking a deep dive into the way SQL Server row mode parallel plans start up. SQL Server executes a query through a process known as a query scan. It is performed by a call from the query processor to CQueryScan::InitQScanRoot. Iterative Execution. PrepRecompute.

Storage 94

Storage Transportation Engineering Processing 94

The Morning Paper

MARCH 10, 2020

So if you want to design a system that will offer good real-world performance, it’s really useful to have benchmarks that accurately represent real-world workloads. So if you want to design a system that will offer good real-world performance, it’s really useful to have benchmarks that accurately represent real-world workloads.

Benchmarking 59

Benchmarking Storage Cache Open Source 59

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). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented.

Servers 95

Servers Tuning Architecture Processing 95

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. Watch this on-demand webinar from Percona to learn how!

Strategy 40

Strategy Storage Database Best Practices 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. © ​​ 2004 Microsoft Corporation. .

Servers 40

Servers Cache Media Hardware 40

Percona

AUGUST 30, 2018

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. One of the common ways to classify database workloads is whether it is “read intensive” or “write intensive”.

Benchmarking 47

Benchmarking Database Operating System Architecture 47

Scalegrid

AUGUST 15, 2019

Since then, however, many new options have emerged to help you optimize your MongoDB management and we thought we’d share our updates. Since then, however, many new options have emerged to help you optimize your MongoDB management and we thought we’d share our updates. We left those at the end of this post for your review.

Database 40

Database Servers Monitoring 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. sort, hash). If it underestimates memory, then you can see spills in tempdb. The Sales.Orders table has about 4.6

Servers 41

Servers Cache Database Metrics 41