Sql Server Analysis Services 2005 Performance Guide
Posted by CJ on February 11, 2007
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
