How to warm up the Analysis Services data cache using Create Cache statement?

(Eric Jacobson and Cristian Petculescu) This document describes how to build Create Cache commands. Create Cache for Analysis Services (AS) was introduced in SP2 of SQL Server 2005. It can be used to make one or more queries run faster by populating the OLAP storage engine cache first.

Read More - Register for Free Membership