Performance Tuning Analysis Services 2008 with Chris Webb
Analysis Services is usually able to answer most queries very quickly, but like all databases it sometimes needs tuning. This day-long seminar will cover all aspects of Analysis Services tuning, including:
- The internal architecture of Analysis Services, and how you can use Profiler and other tools to monitor processing and query execution
- How to use partitioning and aggregations to improve performance
- Caching and cache warming
- Tuning MDX calculations and queries
- Tuning processing of dimensions and cubes
- Scaling up and scaling out, and the influence of hardware on performance
|