|
SSIS package - SSAS Cache Warming Using SSIS |
|
Written by Allan Mitchell
|
|
Wednesday, 05 November 2008 00:18 |
|
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...
|
