Report Portal

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

 

2007-2015 VidasSoft Systems Inc.