Skip to main content
How to warm up the Analysis Services data cache using Create Cache statement?
Entry Date: Rate:
Site:
Keywords:
RSS Description:
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.
Comments:

Warming up cube cache can be an important tasks to achive after cube processing, a good approach is to create an SSIS package for that.