Query Store (QS) is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. QS helps to identify queries that aren’t performing well, or that have regressed in their performance. QS provides detailed information and wait stats that you need to resolve root causes, and it allows you to force the use of a known good execution plan. With SQL Server 2017 and later you can automate the correction of regressions in performance. You'll Learn:
• Troubleshooting Without QS
• Architecture of the QS
• Standard QS Reports
• Demo: Resolving bad Parameter Sniffing with QS : SQL 2016 2017 2019
• Query Store Use Cases
• Query Store Catalog Views
• Configuring QS
• Forcing Plans
• QS Configuration Best Practices
• Auto Plan Correction and Wait Statistics
• What new in SQL Server 2022 QS?
o QS By default
o QS hints
o QS hints Demo: Resolving bad Parameter Sniffing with Query Store : SQL 2022
o Qs for Secondary replica
o Memory grant feedback : Percentile and Persistence mode memory grant feedback
o Degree of parallelism (DOP) feedback.
o Parameter sensitive plan optimization
This is a demo session only with minimum theory & lessons from the fields!