Enterprise Performance Tuning: Best Practices with SQL Server 2008 Analysis Services

Contents

Introduction
Best practices for Cube Design
 Designing Cube Dimensions
  Use Attribute Relationships
  Use Hierarchies Effectively
  Use Numeric keys for dimensions
  Use Usage based optimization
  Set AttributeHierarchyEnabled to False
  Optimizing SQL Source queries
 Designing Partitions
Best Practices for SSAS Configuration
 SSAS configuration
Conclusion

Introduction

SQL Server 2008 Analysis Services provides many architectural enhancements that provide better Cube processing and query performance when compared to SQL Server 2005 Analysis Services. This whitepaper focuses on tips and best practices that help when deploying a large data warehouse.