O'Reilly logo

Pro SQL Server Internals, Second Edition by Dmitri Korotkevitch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_29

29. Query Store

Dmitri Korotkevitch

(1)Tampa, Florida, USA

Query Store is a new SQL Server 2016 component that collects execution plans and runtime statistics for the queries in the system. It helps you to detect suboptimal queries, shows how execution plans evolve over time, and allows you to force specific plans in order to address parameter sniffing–related issues.

This chapter provides an overview of the Query Store, explains how it is integrated into the query processing pipeline, and demonstrates how you can use it during system monitoring and performance troubleshooting.

Why Query Store?

Even though every database system is unique, there are ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required