You searched for "query store" - SQLPerformance.com

Erin Stellato shows how to use Query Store to troubleshoot wait statistics in SQL Server 2017 and Azure SQL Database.

Erin Stellato ◆ November 27, 2017

3

Using DBCC CLONEDATABASE and Query Store for Testing

Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.

Erin Stellato ◆ February 22, 2017

6

The SQL Server Query Store

Benjamin Nevarez (@BenjaminNevarez) gives a very early look at a feature coming soon to Azure SQL Database and SQL Server vNext: the Query Store.

Guest Posts ◆ February 19, 2015

10

Dealing With Explosive sysjobhistory Growth

Aaron Bertrand explains how he fixed a vendor query against sysjobhistory with memory grants so large that SQL Server would shut itself down.

Aaron Bertrand ◆ June 24, 2026

0

The High-Performance DBA: Total Recall, Part 2: SQL Server Memory, Plan Cache, and Query Patterns

In the first post in this series, I walked through how SQL Server uses memory and which configuration habits make life easier for DBAs; in this follow-up, I want to focus on the incidents you actually feel, including plan cache bloat, bad query patterns, and the troubleshooting paths that get you from symptom to root […]

Kevin Kline ◆ May 28, 2026

2

Simple Parameterization and Trivial Plans — Part 3

Paul White continues his series on simple parameterization and trivial plans with a look at the information available in execution plans.

Paul White ◆ April 18, 2022

2

Refreshing SQL Server Tables With Less Interruption Using Partition Switching

Aaron Bertrand talks about using partition switching to load refreshed SQL Server tables without impacting current users.

Aaron Bertrand ◆ September 29, 2021

3

Updated Azure SQL Database Tier Options

Tim Radney explains many new options for Azure SQL Database, including serverless, hyperscale, and hardware configuration optimized for CPU or memory.

Tim Radney ◆ April 27, 2020

0

Bandwidth-friendly Query Profiling for Azure SQL Database

This script to update the default extended events session for ADS Profiler will make for a safer and more bandwidth-friendly query capture experience for Azure SQL Database.

Greg Gonzalez ◆ April 15, 2020

0

An approach to index tuning – Part 2

Erin Stellato concludes her two-part series on her multi-step approach to index tuning in SQL Server.

Erin Stellato ◆ April 13, 2020

1

An approach to index tuning – Part 1

Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations.

Erin Stellato ◆ March 26, 2020

8