Just a reminder that if you already have the SQL 2005 BPA installed it will self-update at your next run. I was impressed to hear this update addresses extensive amounts of memory being paged out. Been there.
SQL Server 2005 Best Practices Analyzer (January 2008) — Now Available!
It’s a new year and, with it, we come bearing gifts! We have a pretty significant update to SQL Server 2005 Best Practices Analyzer. It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools. And all of these rules have rich documentation telling you what need to know.
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.
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.
The documentation is what makes these rules worthwhile. Each new rule has a breakdown of:
- How it was detected
- Why it’s important
- What you should do about it
- Links for more information
Not only will you be able to solve problems with your SQL instances more efficiently, you’ll have a very targeted list of reading material to teach you why it’s important.