SQL Server 2012 Best Practices Analyzer

  • Article

Copied from an internal email from a PM on the team, Jakub -

I’m pleased to announce that SQL Server 2012 Best Practices Analyzer (BPA) has been released and is available for download at https://www.microsoft.com/download/en/details.aspx?id=29302.

Customer Value

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.