Following the original release of SQL Server 2008 R2, the SQL Server 2008 R2 Best Practices Analyzer (BPA) was released in June 2010.
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.
For more information and download information go here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591
Maheshkumar S Tiwari edited Original. Comment: Added tags
Carsten Siemens edited Revision 1. Comment: Pirated Content - see my comment
NOTE: This article was reported as Pirated/Plagiarized Content (content you didn't write) and will be removed. Please do not steal content from others. If you feel we are mistaken, please leave a comment or email tnwiki at Microsoft with a link to this article and with clear and detailed reasons why you own the content or have explicit permission from the author.
Content was taken from: "SQL Server 2008 R2 Best Practices Analyzer is now available"
Published by Matthias Berndt on 18 Jun 2010
blogs.msdn.com/.../sql-server-2008-r2-best-practices-analyzer-is-now-available.aspx