MS released SQL Server 2005 Best Practices Analyzer

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.

This download is the July 2007 release of SQL Server 2005 Best Practices Analyzer.

For SQL Server Analysis Services 2005 this analyzer checks for over 30 rules and prepares nice reports when any of these rules are invalidated.

List of SSAS rules from help file:

• Organize Attributes into Levels in User Hierarchies
• Define Relationships Between Levels in User Hierarchies
• Define Unique Key Columns for Attributes in Natural Hierarchies
• Hide Attributes Used as Levels in User Hierarchies
• Group Attributes Bound to Single Relational Table into a Single Dimension
• Use Only One Non-Aggregatable Attribute per Dimension
• Use Only Aggregatable Attributes in Dimensions with a Parent-Child Hierarchy
• Hide the Key Attribute in a Dimension Containing a Parent-Child Hierarchy
• Increase the Organization of Attributes into Levels in User Hierarchies
• Remove Attributes Below Granularity for All Measure Groups
• Set the Unknown Member Dimension Property to None
• Disable Attributes with 1-1 Relationship with Key Attribute
• Bind the Key Attribute for a Dimension to a Column with a Numeric Data Type
• Design Aggregations for All Measure Groups
• Use Appropriately Sized Partitions in All Measure Groups
• Eliminate Unused Aggregation Designs
• Design Aggregations for Granularity Attribute of Intermediary Dimensions
• Avoid Using Too Many Aggregation Designs
• Minimize the Use of Similar Aggregation Designs
• Place Distinct Count Measures in Separate Measure Groups
• Minimize the Use of Very Large Intermediary Measure Groups
• Split Single-Dimension Cubes into Multiple-Dimension Cubes
• Use the SQL Native Client Provider
• Use MOLAP for Dimensions with Unary Operators, Custom Rollups, and Semi-Additive Measures
• Avoid Linked Dimensions with Unary Operators, Custom Rollups, Semi-Additive Measures, and Calculation Scripts
• Minimize the Use of Unsupported OLE DB Providers
• Materialize Referenced Dimension Relationships
• Minimize the Use of Parent-Child Hierarchies
• Combine Multiple Measure Groups with the Same Dimensionality and Granularity
• Organize Attributes into Dimensions
• Minimize the Number of Measures Groups in a Single Cube
• Use Default Server Property Settings for Most Properties
• Set the Maximum Number of Threads Based on the Number of Processors
• Only Use Proactive Caching with MOLAP

Best Practice Analyzer also checks service security.

You can find test review on SSAS database here.