Cache-warming strategies for Analysis Services 2008

So you've built your cube, designed aggregations and partitions, and spent piles of dosh on start-of-the-art hardware. But still, the first time you run that really complex query, it's slow - even though the second time you run it it runs instantly. What can you do? You need to warm your cache and this session will show you how. You'll find out about the different types of caching Analysis Services is capable of, what to avoid doing to make sure you can cache data, and various methods of warming the cache.
Presented by Chris Webb at SQLBits V
  • Downloads
    Slide deck available Slide Deck 718 KB
    Video available WMV Video 262 MB
    Samples available Demos 3 KB
  • SpeakerBIO
    Chris Webb is an independent consultant specialising in Analysis Services, MDX, Power BI, Power Pivot and Power Query. 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
  • Video