SQLPerformance.com - Page 2 of 33 - SQL Server performance articles curated by SentryOne

Perfect Storm for Upgrading to a Modern Version of SQL Server

Glenn Berry lays out a convincing argument to upgrade to a modern version of SQL Server – considering not only the platform improvements but also changes to Windows, storage, and hardware.

Glenn Berry ◆ September 4, 2018

1

Showplan Enhancements for UDFs

Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer).

Jonathan Kehayias ◆ August 23, 2018

0

Mining Plans : Not just for the plan cache

Erin Stellato shows how to extract patterns and anti-patterns from the plan cache, Query Store, or the SentryOne database.

Erin Stellato ◆ August 16, 2018

0

Optimization Thresholds – Grouping and Aggregating Data, Part 5

In the conclusion of his series on grouping and aggregation costs, Itzik Ben-Gan reveals some of the math behind seek vs. scan decisions.

Itzik Ben-Gan ◆ August 8, 2018

2

Azure SQL Database Performance and Service Tiers Explained

Glenn Berry of SQLskills.com describes the different tiers for Azure SQL Database, and what you get for your money in each case.

Glenn Berry ◆ August 1, 2018

3

Performance Myths: The query result cache

Andy Mallon dispels the myth that SQL Server maintains some kind of query result cache to make future executions of the same query faster.

Guest Posts ◆ July 23, 2018

1

Tracking down high CLR_MANUAL_EVENT waits

Jonathan Kehayias of SQLskills.com shares his story of an unusual situation with high CLR_MANUAL_EVENT waits and how he resolved it.

Jonathan Kehayias ◆ July 18, 2018

2

Optimization Thresholds – Grouping and Aggregating Data, Part 4

In the fourth installment of his series on optimization thresholds, Itzik Ben-Gan looks at how SQL Server applies costs to parallel operations.

Itzik Ben-Gan ◆ July 11, 2018

7

Join Elimination: When SQL Server Removes Unnecessary Tables

For his first guest post on SQLPerformance.com, Bert Wagner describes the pros and cons of join elimination in SQL Server.

Guest Posts ◆ June 18, 2018

0

Optimization Thresholds – Grouping and Aggregating Data, Part 3

Itzik Ben-Gan dissects the Hash Match (Aggregate) algorithm in his latest post in a series on SQL Server optimization thresholds.

Itzik Ben-Gan ◆ June 13, 2018

4

The Importance of Baselines

Tim Radney goes into detail about why baselines are important, and how metrics you collect now can help you solve future problems.

Tim Radney ◆ May 24, 2018

2