This project has moved. For the latest updates, please go here.

Previous Install Plan Explorer Manual Install Install Zoomit Next

Install Plan Explorer SSMS Addin

Finebuild can install Plan Explorer SSMS Addin as part of the SQL Server install process.
If you do not want to include Plan Explorer SSMS Addin in your FineBuild install, then do not download it.

Plan Explorer SSMS Addin was produced by SQL Sentry. An Execution Plan shows the path to be taken by SQL Server to process a given query. Plan Explorer SSMS Addin was chosen to be included in FineBuild because it visualises the execution plan, helps to make it more understandable, and makes this information available within SSMS.

Plan Explorer Home Page https://www.sqlsentry.com/products/plan-explorer/sql-server-query-view
Plan Explorer SSMS Addin download http://downloads.sqlsentry.com/downloads/sqlsentryplanexplorer/SQLSentryPlanExplorerSSMSAddinSetup.msi
Plan Explorer Overview http://greg.blogs.sqlsentry.net/2010/10/sql-sentry-plan-explorer-beta.html
Plan Explorer User Guide http://downloads.sqlsentry.net/downloads/docs/Plan%20Explorer%20User%20Guide.pdf
Plan Explorer Demo Kit http://sqlblog.com/blogs/aaron_bertrand/archive/2011/09/13/a-demo-kit-for-sql-sentry-plan-explorer.aspx

FineBuild Plan Explorer SSMS Addin Install

Automated silent installation of Plan Explorer SSMS Addin is performed by Process Id 4TK and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupPlanExpAddin FULL Yes Yes Yes Yes Yes
SetupSQLTools No No No No No
SetupPlanExpAddin WORKSTATION Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes
SetupPlanExpAddin CLIENT Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes

In order to maintain compatibility with older versions of SQL FineBuild, the parameters InstPlanExplorer and InstSQLTools can also be used.

FineBuild also uses the following parameters to help install Plan Explorer SSMS Addin:
Parameter Default Value Description
PlanExpAddinmsi SQLSentryPlanExplorerSSMSAddinSetup.msi Name of Plan Explorer SSMS Addin install file

Plan Explorer SSMS Addin will be installed with CLIENT and WORKSTATION builds, but not with a FULL build.
If you want to install it with a FULL build, the following parameter should be added at run time:
/SetupSQLTools:Yes
The FineBuild install for Plan Explorer SSMS Addin includes the following:
  • Perform a Plan Explorer SSMS Addin install

Manual Plan Explorer SSMS Addin Install

The following steps show what you would have to do to install Plan Explorer SSMS Addin manually. FineBuild does all of this work for you automatically.

Plan Explorer Install

1) Navigate to the Additional Components folder and double-click on the install file:
Explorer.png
2) The Welcome window is displayed. Click Next to continue.
Welcome.png
3) The License window is displayed. Accept the terms of the license, then click Next to continue.
License.png
4) The Destination Folder window is displayed. Click Next to continue.
Destination.png
5) The Ready to Install window is displayed. Click Install to continue.
Ready.png
6) After the installation has completed, the Completed window is displayed. Click Finish to exit.
Complete.png
Copyright © 2014 Edward Vassie. License and Acknowledgements
Previous Install Plan Explorer Top Install Zoomit Next

Last edited Oct 8, 2014 at 11:23 AM by EdVassie, version 2