The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. With this tool, you can test and implement a combination of SQL Server best practices and then implement them on your SQL Server. The SQL Server 2005 Best Practices Analyzer gathers data from Microsoft Windows and SQL Server configuration settings. Best Practices Analyzer uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.
DOWNLOAD TOOL HERE
Best Practice Analyzer (BPA) Tutorial
Abstract courtesy : Microsoft
Reference : Pinal Dave (https://darkslategrey-bat-805937.hostingersite.com)