WMV files are unsupported

Click here to open the file

SQLBits 2009

Cache-warming strategies for Analysis Services 2008

Learn how the Analysis Services cache works, and how you can pre-load it with data to ensure optimal query performance.
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.