Compare and Analyze Execution Plans

Applies to: SQL Server Azure SQL Managed Instance

This section explains how to compare and analyze execution plans by using Microsoft SQL Server Management Studio. This feature is available starting with SQL Server Management Studio v17.4.

Execution plans graphically display the data retrieval methods chosen by the SQL Server Query Optimizer. Execution plans represent the execution cost of specific statements and queries in SQL Server using icons rather than the tabular representation produced by the SET SHOWPLAN_ALL or SET SHOWPLAN_TEXT statements. This graphical approach is very useful for understanding the performance characteristics of a query.

SQL Server Management Studio includes functionality that allows users compare two execution plans, for example between perceived good and bad plans for the same query, and perform root cause analysis. Also included is the functionality to perform single query plan analysis, allowing insights into scenarios that may be affecting the performance of a query through analysis of its execution plan.

For more information on query execution plans, see estimated execution plan, actual execution plan, and the Query Processing Architecture Guide.

In This Section

Compare Execution Plans
Analyze an Actual Execution Plan