Query Store for SQL Server 2019January 31, 2021
Query Store for SQL Server 2019
- Author: Grant Fritchey, Tracy Boggiano
- ISBN: 1484250036
- Year: 2019
- Pages: 219
- Language: English
- File size: 9.7 MB
- File format: PDF, ePub
- Category: SQL
Use the new Query Store attribute to recognize and fix poorly performing queries in SQL Server.
Query Store is an important and current feature in SQL Server that provides insight into the particulars of query execution and how that implementation has changed over time. Query Store helps identify questions that aren’t performing well, or that have regressed in their own performance. Query Store provides detailed information like wait stats which you need to resolve root causes, and it lets you force the use of a known good implementation plan. With SQL Server 2017 and later you can automate the correction of regressions in functionality.
Query Store for SQL Server 2019 helps you protect your database’s performance during upgrades of version or applications of SQL Server. The book provides basic information on how Query Store works and best practices for implementation and use. You will learn how to run and translate built-in accounts, configure automated plan correction, and troubleshoot questions using Query Store when needed. Anyone responsible for identifying poorly performing queries are going to have the ability to use Query Store to find these queries and resolve the underlying problems.