SentryOne Team Blog (blogs.sentryone.com)

SQLPerformance.com

SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the "how" and the "why."
Jonathan Kehayias : Showplan Enhancements for UDFs

Jonathan Kehayias : 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).

Erin Stellato : Mining Plans : Not just for the plan cache

Erin Stellato : 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.

Itzik Ben-Gan : Optimization Thresholds : Grouping and Aggregating Data, Part 5

Itzik Ben-Gan : 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.

Glenn Berry : Azure SQL Database Tiers Explained

Glenn Berry : Azure SQL Database 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.

Andy Mallon : Performance Myths : The query result cache

Andy Mallon : 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.

Jonathan Kehayias : Tracking down high CLR_MANUAL_EVENT waits

Jonathan Kehayias : 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.

Itzik Ben-Gan : Optimization Thresholds : Grouping & Aggregating Data, Part 4

Itzik Ben-Gan : Optimization Thresholds : Grouping & 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.

Bert Wagner : Join Elimination

Bert Wagner : Join Elimination

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

Itzik Ben-Gan : Optimization Thresholds : Grouping & Aggregating Data, Part 3

Itzik Ben-Gan : Optimization Thresholds : Grouping & 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.

Tim Radney : The Importance of Baselines

Tim Radney : 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.

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 2

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 2

Continuing his series on optimization thresholds, Itzik Ben-Gan dives into the costs behind stream aggregates when the data needs to be sorted first.

Glenn Berry : Reasons to Upgrade to SQL Server 2017

Glenn Berry : Reasons to Upgrade to SQL Server 2017

Glenn Berry discusses a number of compelling reasons why, if you are choosing between SQL Server 2016 or SQL Server 2017, you should choose the newer version. Continue reading…

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 1

Itzik Ben-Gan : Optimizer Thresholds : Grouping & Aggregating, Part 1

For his first post on SQLPerformance.com, Itzik Ben-Gan shows you how to reverse engineer optimizer costing for a Stream Aggregate operator.

Erin Stellato : Automatic Index Management in Azure SQL Database

Erin Stellato : Automatic Index Management in Azure SQL Database

Following up on her post about automatic plan correction, Erin Stellato talks about a new feature in Azure SQL Database: Automatic Index Management.

Rob Farley : Dealing with date and time instead of datetime

Rob Farley : Dealing with date and time instead of datetime

Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance.