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
Slide Deck 718 KB
WMV Video 262 MB
Demos 3 KB