Jun 222010
Microsoft has been doing a great job at releasing new best practice analyzers. They have now released one for SQL Server 2008 R2. The analyzer will look at things like event logs, permissions, and SQL metadata. The BPA will provide recommendations for any warnings or problems. You can download the BPA by following the link below.
BPA For SQL 2008 R2
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591
