SQL Server 2008 R2 Best Practices Analyzer (BPA) is a diagnostic tool which 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 - go here
If you face any issue installing SQL 2008 R2 BPA relating to Remoting, refer this link
If you’re not a subscriber, you can have msigeek blog notifications delivered to you free via these options: RSS Updates , Email Updates and SMS Alerts.
About Author: Vijay is a passionate Technology Evangelist & a Microsoft MVP in Application Setup / Deployment. 