The Microsoft SQL Server 2008 R2 Best Practices Analyzer (BPA), using the BPA tool, a DBA can quickly gather information from Microsoft Windows and SQL Server configuration settings.
The Microsoft SQL Server 2008 R2 Best Practices Analyzer (BPA) is an excellent tool which is available as a free download from Microsoft. Using the BPA tool, a DBA can quickly gather information from Microsoft Windows and SQL Server configuration settings. The BPA tool basically uses a predefined set of SQL Server 2008 R2 recommendations and best practices to identify potential issues within the database environment.