Comparative Analysis of Query Plans

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

Get Learn T-SQL Querying now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.