Systems Engineering and RDBMS

SQL Server 2005 Best Practices Analyzer

Posted by decipherinfosys on January 22, 2008

Microsoft released their SQL Server 2005 best practices analyzer recently. Here is the URL from where you can download it from:

http://www.microsoft.com/downloads/details.aspx?FamilyId=da0531e4-e94c-4991-82fa-f0e3fbd05e63&displaylang=en

The installation is pretty simple.  There have been a good number of enhancements including detecting any design issues in cube design for Analysis Services, memory issues etc..  The best thing about this edition is the rich documentation that comes along with it explaining the observations as well as URLs pointing to more material available at MSDN and KB articles which would help in getting a good grasp on the issue.  In the next release (SQL Server 2008), BPA is supposed to be integrated into the tools and not as a separate download.

One Response to “SQL Server 2005 Best Practices Analyzer”

  1. […] second one from MSFT would be the SQL Server 2005 Best Practices Analyzer. Use this for checking SQL Server instances for any known security […]

Sorry, the comment form is closed at this time.

 
%d bloggers like this: