Introduction to Performance Tuning Analysis Services 2008

So you've gone to all the trouble of building a cube, and your users are complaining that their queries are still too slow? This session will show you how to tune query performance on Analysis Services 2008, looking at partitioning, designing aggregations and identifying MDX-related bottlenecks.
Presented by Chris Webb at SQLBits VI
  • Downloads
    Slide deck available Slide Deck 86 KB
    Video available WMV Video 225 MB
    Samples available MDX Demos 4 KB
  • SpeakerBIO
    Chris_Webb.jpg
    Chris Webb is an independent consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is the author of "Power Query for Power BI and Excel" and a co-author of "SQL Server Analysis Services 2012: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase". He blogs at http://cwebbbi.wordpress.com/ 
    http://cwebbbi.wordpress.com/ http://feeds.feedburner.com/wordpress/Cpjz
  • Video