SQL Server 2012 Best Practices Analyzer

SQL Server 2012 Best Practices Analyzer

Rate This
  • Comments 4

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 http://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.


Leave a Comment
  • Please add 3 and 1 and type the answer here:
  • Post
  • Can we get a one click uninstall for SQL 2012 instead of the multiple components showing up for Sql 2008 r2?

  • Is there any Whitepaper available? By now I have some trouble running the BPA

  • Dirk, unfortunately there isn't a whitepaper for it.

  • Installed the MS Baseline Configuration Analyzer 2.0 on Win 2012 server running SQL Server 2012. Installed SQL Server 2012 BPA (appeared to install successfully). Launched MS Baseline Config Analyzer (GUI) and don't see any options under 'Select a product'  - was expected to see the SQL Server 2012 BPA. Anything I need to check / update to get this to show up under 'Select a product'?

Page 1 of 1 (4 items)