Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Wednesday, February 08, 2012

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 

FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

User Rating!

Home > Search > Articles & Samples > SQL Server > Cache
Build Your Own Analysis Services Cache-Warmer in Integration Services        
Total Hits: 165  |  Today: 0 Author: cwebbbi.spaces.live       Rating:  
Read Reviews | Write Review | Your Rating: 

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 ..

DevASP.Net users Rating
What is your opinion?
Is this your listing?

    If this is your listing and you like to add the rating box
    displayed on the right side on your site you can use the following code.

Go Back
DevASP.Net - Disclaimer - Privacy
© 2002-2010 DevASP.net