The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.
This download is the August 2008 release of SQL Server 2005 Best Practices Analyzer.
Download Best Practices Analyzer
Abstract courtesy : Microsoft
Reference : Pinal Dave (https://blog.sqlauthority.com)