Install SQL Best Practice Analyzer

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

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. The most recent version of this product is for SQL 2012 and it is no longer supported by Microsoft.

SQL Best Practice Analyzer is no longer supported by Microsoft. However, if you install SQL Best Practice Analyzer you must also Install Baseline Configuration Analyzer.

Item	Location
SQL Best Practice Analyzer home page	See SQL Server 2012 Feature Pack https://www.microsoft.com/en-us/download/details.aspx?id=56041
SQL Best Practice Analyzer download SQL 2012	https://www.microsoft.com/download/en/details.aspx?id=29302
SQL Best Practice Analyzer download SQL 2008 R2	This download is no longer available
SQL Best Practice Analyzer download SQL 2005	This download is no longer available
SQL Best Practice Analyzer Tutorial by Pinal Dave	https://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:

SQL Version	Parameter	FULL Build	WORKSTATION Build	CLIENT Build
SQL2019	/SetupBPAnalyzer	N/A	N/A	N/A
	/SetupSQLTools:	No	Yes	Yes
SQL2017	/SetupBPAnalyzer:	N/A	N/A	N/A
	/SetupSQLTools:	No	Yes	Yes
SQL2016	/SetupBPAnalyzer:	N/A	N/A	N/A
	/SetupSQLTools:	No	Yes	Yes
SQL2014	/SetupBPAnalyzer:	N/A	N/A	N/A
	/SetupSQLTools:	No	Yes	Yes
SQL2012	/SetupBPAnalyzer:	Yes	Yes	Yes
	/SetupSQLTools:	No	Yes	Yes
SQL2008R2	/SetupBPAnalyzer:	Yes	Yes	Yes
	/SetupSQLTools:	No	Yes	Yes
SQL2008	/SetupBPAnalyzer:	Yes	Yes	Yes
	/SetupSQLTools:	No	Yes	Yes
SQL2005	/SetupBPAnalyzer:	Yes	Yes	Yes
	/SetupSQLTools:	No	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 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 or for SQL 2014 and above. 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:

Install SQL Best Practice Analyzer
Setup Best Practice Analyzer Menu Item

Top

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.