In Chapter 4, Exploring Query Execution Plans, we discussed how to access query plans, how to navigate a query plan, and what properties we can look for when analyzing query performance issues. That was a manual process until recently. Back in 2015, SSMS introduced rich-UI features to make query plan analysis easier. This chapter will introduce the query plan comparison and query plan analysis functionalities in SSMS, to help streamline the process of troubleshooting certain classes of issue with query performance.
In this chapter, we will cover the following tools for query plan analysis:
- Query Plan Comparison
- Query Plan Analyzer