“The 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”

The SQL Server 2012 Best Practices Analyzer can be downloaded from the following link.