Download Microsoft SQL Server 2012 Best Practices Analyzer

Microsoft SQL Server 2012 Best Practices Analyzer (BPA) is now available for download. Microsoft SQL Server 2012 BPA is a diagnostic tool that performs the following functions:

• Gathers information about a Server and a Microsoft SQL Server 2012 instance installed on that Server.
• Determines if the configurations are set according to the recommended best practices.
• Reports on all configurations, indicating settings that differ from recommendations.
• Indicates potential problems in the installed instance of SQL Server.
• Recommends solutions to potential problems.

Microsoft SQL Server 2012 BPA are now available for download at the links below. Download the files appropriate for you.

• Microsoft SQL Server 2012 BPA 32-bit (SQL2012BPA_Setup32.msi)
• Microsoft SQL Server 2012 BPA 64-bit (SQL2012BPA_Setup64.msi)

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:

• PowerShell V2.0
• Microsoft Baseline Configuration Analyzer V2.0

Important:
Microsoft SQL Server 2012 BPA is able to scan both the local computer and remote computers. Therefore, in both the local and remote cases, it is required that your PowerShell settings be modified. The modifications support PowerShell remoting, and increase maximum number of concurrent shells for a user. For the more information and installation instructions, please visit Microsoft SQL Server 2012 Best Practices Analyzer website.