Search - Articles - Dev Forums - Favorites - Member Login  
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Thursday, September 09, 2010

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

Add Review and Rate the listing.

Home > Search > Articles & Samples > SQL Server > Cache
Build Your Own Analysis Services Cache-Warmer in Integration Services        
Total Hits: 151  |  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 ..

If you would like to add your review of the above resource please complete the form below. All reviews are screened before they are posted on the website. Any malicious, vulgar, or unsubstantiated reviews will be removed.

Review Title:   *
Your Full Name:   *
Email Address:  
Email address will not be displayed with review.
Your Comments: *
Your Rating: *
   

<< Back to listing

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