Microsoft SQL Server 2008 R2 Best Practice Analyzer

Microsoft had released an amazing tool that would analyze your SQL installation and produce report detailing some of the settings that don’t meet Microsoft recommendation or would say Best Practice. I must say this tool is quite useful and could help you as DBA administrator identify some loopholes and resolve but note that not all settings may be applicable in your environment. Functions: The Microsoft SQL Server 2008 R2 Best Practices Analyzer (BPA) tool performs the following functions: – Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server