Following the original release of SQL Server 2008 R2 we are pleased to announce the associated release of the SQL Server 2008 R2 Best Practices Analyzer (BPA).
BPA is designed for administrators who want to determine the overall conformance of their SQL Server instances and topology with established best practices. BPA examines your SQL Server instance for system events, reviews login permissions, scans your SQL Metadata for advisable settings, and recommends solutions to items that do not conform with established Microsoft best practices.
BPA runs within the framework of the Microsoft Baseline Configuration Analyzer (MBCA 2.0) and supports both, SQL Server 2008 and SQL Server 2008 R2. It is supported on a variety of operating systems including Windows Server 2003, Windows Server 2008, Windows 7.
As always, we appreciate your feedback. Subsequent releases will “learn” from experiences of our customer base and we plan on expanding the best practices portfolio over time.
For more information and download information go here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591
Dana H. Burnell
Microsoft SQL Server