SQL Server 2005 Best Practices Analyzer (January 2008)
Source: David Hayden, Filed: SQL Server
The SQL Server 2005 Best Practices Analyzer ( January 2008 ) appears to be a significant update. It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, and a couple bug fixes for the UI and command line tools.
According to the Microsoft SQL Server Development Customer Advisory Team Blog here are a few points on the new rules for Analysis Services and the Relational Engine:
“Analysis Services
In the last release, only a few rules for Analysis Services would be displayed. These were mainly around security. With this release, we detect potential issues with the design of your cubes. If you have taken a look at SQL Server 2008, you’ll see that these are the same warnings you’ll find in Business Intelligence Development Studio. Thus, the recommendations from SQL BPA will be perfectly in sync with the recommendations from SQL Server 2008.
Relational Engine
We have worked closely with CSS to identify a number of common issues that customers have been facing. In SQL Server 2005 Service Pack 2, we started logging events regarding extensive amount of memory being paged out. With this update of BPA, it will check to see if this happened and let you know if can determine the root cause.“
You can download the updated SQL Server 2005 Best Practices Analyzer here.