:::: MENU ::::

How to enable actual execution plan in SSMS

  • Apr 21 / 2009
  • 2
dbDigger, Execution plans, Performance Tunning and Optimization, SSMS tips and tricks

How to enable actual execution plan in SSMS

While optimizing T-SQL code execution plans are may provide useful information. To enable actual execution plan for a query pane in SSMS.

Enable Actual execution Plan in SSMS

Once enabled for a query pane, it will remain enable as long as removed by same way as included. Once T-SQL code is executed query plan will generated in a tab with results and messages tab.

Actual Execution plan in SSMS

  • Anonymous

    I am greatly interested in understanding and using SQL Server execution plans. Please suggest a book or best article for start working with SQL Server execution plans.

  • Atif Shehzad

    You can download a good and comprehensive book for SQL Srever execution plans from folowing address http://blog.dbdigger.com/2009/04/dowanload-dissecting-sql-server.html

Consult us to explore the Databases. Contact us