Sql Server Analysis Services 2005 Performance Guide

Microsoft has recently released their SSAS 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