Microsoft SQL Server 2012 Best Practices Analyzer is a diagnostic tool that gathers information about all the SQL Server 2012 components installed on the system and determines if the configurations are setup according to the recommended best practices.
It indicates potential problems with the SQL Server installation and recommends a solution.
You can download the tool from here
The pre-requisites are:
System requirements
Supported operating systems: Windows 7, Windows Server 2008, Windows Server 2008 R2
The following are required for using SQL Server 2012 Best Practices Analyzer (BPA):
PowerShell V2.0
Microsoft Baseline Configuration Analyzer V2.0
I tried installing BPA on my Windows 2008R2 development environment and it prompted me with this message: “Microsoft Baseline Configuration Analyzer 2.0 is not installed….”
So, I went ahead and installed the Baseline Configuration Analyzer 2.0
After that the BPA setup completed with no problem:
Here is a real quick video of SQL Server BPA in action:
