Book description
Apply the new Query Store feature to identify and fix poorly performing queries in SQL Server.- Apply best practices in implementing Query Store on production servers
- Detect and correct regressions in query performance
- Lower the risk of performance degradation following an upgrade
- Use tools and techniques to get the most from Query Store
- Automate regression correction and other uses of Query Store
Table of contents
- Cover
- Front Matter
- 1. What Is Query Store?
- 2. Overview and Architecture of the Query Store
- 3. Configuring Query Store
- 4. Standard Query Store Reports
- 5. Query Store Catalog Views
- 6. Query Store Use Cases
- 7. Forcing Plans
- 8. Auto Plan Correction and Wait Statistics
- 9. Troubleshooting Issues with Query Store
- 10. Community Tools
- Back Matter
Product information
- Title: Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries
- Author(s):
- Release date: October 2019
- Publisher(s): Apress
- ISBN: 9781484250044
You might also like
book
SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and …
book
Microsoft SQL Server 2014 Query Tuning & Optimization
Optimize Microsoft SQL Server 2014 queries and applications Microsoft SQL Server 2014 Query Tuning & Optimization …
book
Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers
Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL …
book
Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond
Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring …