Summary

This chapter covered the important topic of storing query performance statistics in the flight recorder, which is the Query Store, which allows us to access query plans and their runtime statistics, along with how they change over time. With what we’ve learned so far in all the previous chapters of this book (especially in Chapter 3, Exploring Query Execution Plans, about what information lies inside query plans), we can now more easily find resolutions for performance problems. We can easily identify plans that must be tuned, or for quick mitigation, just return to a known good plan that had been stored in Query Store. We also learned how the Query Store enables several helpful features that allow the Query Optimizer to automatically detect and correct common query performance issues.

Finally, we covered how to use either system views or SSMS to uncover the highest resource-consuming queries executing in our databases and help us quickly find and fix query performance...