Microsoft has published a 120 page Analysis Services 2005 Performance Guide.
Major topics from the contents page include:
- Enhancing Query Performance
- Understanding the querying architecture
- Optimizing the dimension design
- Maximizing the value of aggregations
- Using partitions to enhance query performance
- Writing efficient MDX
- Tuning Processing Performance
- Understanding the processing architecture
- Refreshing dimensions efficiently
- Refreshing partitions efficiently
- Optimizing Special Design Scenarios
- Special aggregate functions
- Parent-child hierarchies
- Complex dimension relationships
- Near real-time data refreshes
- Tuning Server Resources
- Understanding how Analysis Services uses memory
- Optimizing memory usage
- Understanding how Analysis Services uses CPU resources
- Optimizing CPU usage
- Understanding how Analysis Services uses disk resources
- Optimizing disk usage
The guide is currently applicable to SQL Server Service Pack 2. We hope this is an indication that it will become a living document with further contributions and enhancements as SSAS 2005 evolves and further expert knowledge is acquired through research and practical experience.
Congratulations to the authors and subject matter experts who contributed to this document. As Mosha Pasumansky (one of the contributing subject matter experts) says on his blog "This guide is a big deal, and anybody serious about Analysis Services 2005 should download it and read from end to end."
Business Intelligence and Performance Management Home