SSIS package - SSAS Cache Warming Using SSIS
Having your users walk into a cold cache on a morning is something that will cause them to have slower running queries initially. Cache warming takes care of a lot of that by executing typical queries against the newly processed cube and thereby building the cache ready for your users when they get in. There are a number of ways to warm the cache available.
Chris Webb has already blogged about how he has done it and we thought we would show you a variation on that theme.
Read more about this script...Tags: performance, ssis, script