One of the most useful tools for SQL Server 2005 was the SQL Server Best Practices Analyzer (BPA).
Best Practices were produced for SQL Server 2008 Policy Based Management, yet there was still demand for a a standalone version of BPA.
Well, now it’s here! SQL Server 2008 R2 Best Practices Analyzer will gather information and determine configuration for Microsoft SQL Server 2008 or 2008 R2 instances and determine if they meet recommended best practices. It can also suggest solutions to potential issues.
The utility encompasses rules for:
The tool can be run against servers locally or remotely, using a GUI or Command Line.
OS support includes:
You can download it here from the Microsoft Download Center.
Get it, get it now. You’ll be glad you did.