AKAWN® LIMITED

SQL Server specialists

SQL Server Best Practices Analyzer

The free Microsoft SQL Server Best Practices Analyzer (BPA) is a safe to run diagnostic tool which performs a mini Health Check on your SQL Server instance. The BPA primarily:

  • Checks the SQL Server instance against standard recommended best practices. (It is noted that some applications have specific configuration requirements and therefore may deviate for standard best practices e.g. BizTalk, SharePoint…)
  • Reports on deviations from standard best practices.
  • Recommends solutions to potential issues.

Below are the current BPA releases:

 

Microsoft SQL Server 2012

Version Published Comment
1.0.0.0 2012 Apr Requires MBCA 2.1.

Microsoft SQL Server 2008 R2

Version Published Comment
10.50.9810.10 2010 Jun Requires MBCA 2.1. Also supports SQL Server 2008.

Microsoft SQL Server 2008

Version Published Comment
10.50.9810.10 2010 Jun Requires MBCA 2.1. Also supports SQL Server 2008 R2.

Microsoft SQL Server 2005

Version Published Comment
9.00.1009.00 2008 Aug

Microsoft SQL Server 2000

Version Published Comment
1.0 2010 Apr