Previous Install XML Notepad Manual Install Install Plan Explorer SSMS Addin Next

Install Plan Explorer

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

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

Plan Explorer Home Page https://www.sqlsentry.com/products/plan-explorer/sql-server-query-view
Plan Explorer download x64 http://downloads.sqlsentry.com/downloads/sqlsentryplanexplorer/x64/SQLSentryPlanExplorerSetup-x64.msi
Plan Explorer download x86 http://downloads.sqlsentry.com/downloads/sqlsentryplanexplorer/x64/SQLSentryPlanExplorerSetup-x86.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 Install

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

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupPlanExplorer FULL Yes Yes Yes Yes Yes
SetupSQLTools No No No No No
SetupPlanExplorer WORKSTATION Yes Yes Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes
SetupPlanExplorer 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:
Parameter Default Value Description
PlanExpX64msi SQLSentryPlanExplorerSetup-x64.msi Name of Plan Explorer install file for 64-bit servers
PlanExpX64msi SQLSentryPlanExplorerSetup-x86.msi Name of Plan Explorer install file for 32-bit servers

Plan Explorer 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 includes the following:
  • Perform a Plan Explorer install

Manual Plan Explorer Install

The following steps show what you would have to do to install Plan Explorer 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 relevant install file:
Processor File
64-bit SQLSentryPlanExplorerSetup-x64.msi
32-bit SQLSentryPlanExplorerSetup-x86.msi

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) Wait while Plan Explorer is installed.
Progress.png
7) 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 XML Notepad Top Install Plan Explorer SSMS Addin Next

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