Skip to content

display-an-actual-execution-plan.md

Latest commit

 

History

History
38 lines (28 loc) · 2.7 KB

display-an-actual-execution-plan.md

File metadata and controls

38 lines (28 loc) · 2.7 KB
title Display an Actual Execution Plan | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology performance
ms.topic conceptual
helpviewer_keywords
displaying execution plans
actual execution plans
viewing execution plans
execution plans [SQL Server], displaying
ms.assetid 9e583a18-5f4a-4054-bfe1-4b2a76630db6
author MikeRayMSFT
ms.author mikeray
manager craigg

Display an Actual Execution Plan

This topic describes how to generate actual graphical execution plans by using [!INCLUDEssManStudioFull]. When actual execution plans are generated, the [!INCLUDEtsql] queries or batches execute. The execution plan that is generated displays the actual query execution plan that the [!INCLUDEssDEnoversion] uses to execute the queries.

To use this feature, users must have the appropriate permissions to execute the [!INCLUDEtsql] queries for which a graphical execution plan is being generated, and they must be granted the SHOWPLAN permission for all databases referenced by the query.

To include an execution plan for a query during execution

  1. On the [!INCLUDEssManStudioFull] toolbar, click Database Engine Query. You can also open an existing query and display the estimated execution plan by clicking the Open File toolbar button and locating the existing query.

  2. Enter the query for which you would like to display the actual execution plan.

  3. On the Query menu, click Include Actual Execution Plan or click the Include Actual Execution Plan toolbar button

  4. Execute the query by clicking the Execute toolbar button. The plan used by the query optimizer is displayed on the Execution Plan tab in the results pane. Pause the mouse over the logical and physical operators to view the description and properties of the operators in the displayed ToolTip.

    Alternatively, you can view operator properties in the Properties window. If Properties is not visible, right-click an operator and select Properties. Select an operator to view its properties.

  5. You can alter the display of the execution plan by right-clicking the execution plan and selecting Zoom In, Zoom Out, Custom Zoom, or Zoom to Fit. Zoom In and Zoom Out allow you to zoom in or out on the execution plan, while Custom Zoom allows you to define your own zoom, such as zooming at 80 percent. Zoom to Fit magnifies the execution plan to fit the result pane.