Learn T-SQL Querying

Summary

This chapter covered the important topic of storing query performance statistics in the flight recorder that 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 4, 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 for a quick mitigation, just to return a known good plan that had been stored in the Query Store.

We covered how to use either system views or SSMS to uncover the highest resource consuming queries that are executing ...