Previous Install Linked Report Generator Manual Install Install Java DBC Driver Next

Install SQL Best Practice Analyzer

FineBuild can install and configure the SQL Best Practice Analyzer (BPA) as part of the SQL Server install process.
If you do not want to include SQL Best Practice Analyzer in your FineBuild install, then do not download it.

SQL Best Practice Analyzer is written by Microsoft. It was chosen to be included in FineBuild because it allows various aspects of the SQL Server configuration and database configuration to be checked against Microsoft best practice.

If you install SQL Best Practice Analyzer you must also Install Baseline Configuration Analyzer.

SQL Best Practice Analyzer home page See SQL Server Feature Pack http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en
SQL Best Practice Analyzer download SQL 2014 http://www.microsoft.com/download/en/details.aspx?id=29302
SQL Best Practice Analyzer download SQL 2012 http://www.microsoft.com/download/en/details.aspx?id=29302
SQL Best Practice Analyzer download SQL 2008 R2 http://www.microsoft.com/download/en/details.aspx?id=15289
SQL Best Practice Analyzer download SQL 2005 http://www.microsoft.com/download/en/details.aspx?id=23864
SQL Best Practice Analyzer Tutorial by Pinal Dave http://blog.sqlauthority.com/2007/07/05/sql-server-2005-best-practices-analyzer-tutorial-sample-example/

FineBuild SQL Best Practice Analyzer Install

Automated silent installation of SQL Best Practice Analyzer is performed by Process Id 4SA and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupBPAnalyzer FULL Yes N/A Yes Yes Yes
SetupSQLTools No No No No No
SetupBPAnalyzer WORKSTATION Yes N/A Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes
SetupBPAnalyzer CLIENT Yes N/A Yes Yes Yes
SetupSQLTools Yes Yes Yes Yes Yes

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

FineBuild also uses the following parameters to help install Best Practice Analyzer:
Parameter SQL Version Default Value Description
BPAX86msi SQL 2014 SQL2014BPA_Setup32.msi Name of Best Practise Analyzer install file for 32-bit systems
BPAX64msi SQL 2014 SQL2014BPA_Setup64.msi Name of Best Practise Analyzer install file for 64-bit systems
BPAX86msi SQL 2012 SQL2012BPA_Setup32.msi Name of Best Practise Analyzer install file for 32-bit systems
BPAX64msi SQL 2012 SQL2012BPA_Setup64.msi Name of Best Practise Analyzer install file for 64-bit systems
BPAX86msi SQL 2008 R2 SQL2008R2BPA_Setup32.msi Name of Best Practise Analyzer install file for 32-bit systems
BPAX64msi SQL 2008 R2 SQL2008R2BPA_Setup64.msi Name of Best Practise Analyzer install file for 64-bit systems
BPAX86msi SQL 2005 SQLBPASetup.msi Name of Best Practise Analyzer install file for 32-bit systems
BPAX64msi SQL 2005 SQLBPASetup.msi Name of Best Practise Analyzer install file for 64-bit systems

SQL Best Practice Analyzer is NOT available for SQL 2008. Also, it will only 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 SQL Best Practice Analyzer includes the following:
  • Perform a SQL Best Practice Analyzer install
  • Setup SQL Best Practice Analyzer menu item

Manual SQL Best Practice Analyzer Install

The following steps show what you would have to do to install SQL Best Practice Analyzer manually. FineBuild does all of this work for you automatically. The process for installing BPA for SQL 2005 is shown, and a similar process is used for BPA for SQL 2008 R2.

Install SQL Best Practice Analyzer

1) Navigate to the Additional Components folder and double-click on the following:
SQL 2014 X86 SQL2014BPA_Setup32.msi
SQL 2014 X64 SQL2014BPA_Setup64.msi
SQL 2012 X86 SQL2012BPA_Setup32.msi
SQL 2012 X64 SQL2012BPA_Setup64.msi
SQL 2008 R2 X86 SQL2008R2BPA_Setup32.msi
SQL 2008 R2 X64 SQL2008R2BPA_Setup64.msi
SQL 2005 SQLBPASetup.msi

BPAExplorer.png
2) The Welcome screen is displayed. Click Next to continue.
BPAWelcome.png
3) Accept the License Agreement and click Next to continue.
BPALicense.png
4) Enter the Registration Information and click Next to continue.
BPARegistration.png
5) Accept the defaults for Feature Selection. Click Next to continue.
BPAFeatures.png
6) Setup is ready to begin installation. Click Install to continue.
BPAReady.png
7) Setup has installed the SQL Best Practices Analyzer successfully. Click Finish to end.
BPAComplete.png

Setup Best practice Analyzer Menu Item

The menu for SQL Server BPA to the Microsoft SQL Server menu structure, so that all tools for SQL Server are found in one place.

1) Navigate to Start -> All programs. Right-click on SQL Server BPA and select Explore.
BPAMenuExplore.png
2) Drag the SQL Server BPA folder to the Microsoft SQL Server 20xx\Configuration Tools folder.
BPAMenuDrag.png
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install Linked Report Generator Top Install Java DBC Driver Next

Last edited Oct 23, 2014 at 11:43 AM by EdVassie, version 20