SSAS Articles Performance Tuning Build Your Own Analysis Services Cache-Warmer in Integration Services (by Chris Webb)
Build Your Own Analysis Services Cache-Warmer in Integration Services (by Chris Webb)
User Rating: / 0
PoorBest 
Written by Chris Webb   
Saturday, 19 May 2007 18:15

Cache-warming is one of the most neglected performance-tuning techniques for Analysis Services: perhaps it seems too much like cheating? Yet almost everyone knows how much difference there can be executing a query on a cold cache and a warm cache so there should be no excuse not to be doing it, especially if you know what queries your users are likely to be running in advance. AS2005's caching mechanism is more complex than I can describe here (or than I can describe full stop - although I hear that the recently published "Microsoft Analysis Services 2005" has some great information on this front) but a lot of the time it can cache raw data of the cube and quite often the results of calculations too; you'll need to test your own cubes and queries to find out exactly how much you'll benefit but almost every cube benefits to a noticeable extent.

I've recently implemented a simple cache-warming system for a few customers which I thought I'd share details of. Now I know that the documentation for asmd contains details of how you can use it for this purpose (see http://msdn2.microsoft.com/en-us/library/ms365187.aspx for details) but I didn't go down this route for a number of reasons:

Read more...