http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspxGoal 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.en-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#2317376Sun, 29 Apr 2007 02:35:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:2317376SQLBI - Marco Russo<p>Chris Webb has recently released a really interesting tool: MDX Script Performance Analyzer . It's a</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#4581656Mon, 27 Aug 2007 05:11:23 GMT91d46819-8472-40ad-a661-2c78acb4018c:4581656Microsoft OLAP by Mosha Pasumansky<p>After writing my previous blog post about dynamic named sets , I received feedback from multiple people</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#4581668Mon, 27 Aug 2007 05:12:15 GMT91d46819-8472-40ad-a661-2c78acb4018c:4581668Microsoft OLAP by Mosha Pasumansky<p>After writing my previous blog post about dynamic named sets, I received feedback from multiple...</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#4896783Thu, 13 Sep 2007 20:09:05 GMT91d46819-8472-40ad-a661-2c78acb4018c:4896783Top 10 Lists<p>Author: Carl Rabeler Proper cube design, efficient multidimensional expressions (MDX), and sufficient</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#5994736Thu, 08 Nov 2007 22:59:06 GMT91d46819-8472-40ad-a661-2c78acb4018c:5994736Houston Mortgage Broker<p>Hello, I thought that just by issuing an MDX query, i.e. from Pivot Table or SSMS, then cache would be created. &nbsp;</p> <p>Why do we need to use the create cache statement? &nbsp;</p> <p>When I run profiler, I see that queries from Pivot Tables don't have the &quot;create cache&quot; at the head of the MDX. &nbsp;I do know these queries are cached without using the &quot;create cache&quot;. &nbsp;</p> <p>Thanks,</p> <p>Jason </p>http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#6783695Sun, 16 Dec 2007 19:55:28 GMT91d46819-8472-40ad-a661-2c78acb4018c:6783695Top 10 Lists<p>Author: Carl Rabeler Proper cube design, efficient multidimensional expressions (MDX), and sufficient</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#7523156Thu, 07 Feb 2008 21:58:32 GMT91d46819-8472-40ad-a661-2c78acb4018c:7523156Technical Spotlights<p>Author: Carl Rabeler Proper cube design, efficient multidimensional expressions (MDX), and sufficient</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#8576691Fri, 06 Jun 2008 04:16:19 GMT91d46819-8472-40ad-a661-2c78acb4018c:8576691Weddings<p>Goal 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</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#8867212Thu, 14 Aug 2008 19:19:33 GMT91d46819-8472-40ad-a661-2c78acb4018c:8867212sqljunkies.com<p>After writing my previous blog post about dynamic named sets , I received feedback from multiple people</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#9003632Fri, 17 Oct 2008 23:26:29 GMT91d46819-8472-40ad-a661-2c78acb4018c:9003632техническая документация на русском<p>Автор: Карл Рабелер (Carl Rabeler) Надлежащим образом построенные кубы, эффективные многомерные выражения</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#9003747Sat, 18 Oct 2008 00:41:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:9003747中文（简体）白皮书<p>作者 ： Carl Rabeler 在针对 SQL Server 2005 Analysis Services 实例进行 MDX 查询时，要想获得最佳性能，关键要做到以下几点：合理的多维数据集设计、有效的多维表达式</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#9005025Sat, 18 Oct 2008 19:08:54 GMT91d46819-8472-40ad-a661-2c78acb4018c:9005025ホワイトペーパー（日本語）<p>&amp;#160; 執筆者 : Carl Rabeler 適切なキューブ デザイン、効率的な多次元式 (MDX)、および十分なハードウェア リソースは、SQL Server 2005 Analysis Services</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#9024941Thu, 30 Oct 2008 21:00:33 GMT91d46819-8472-40ad-a661-2c78acb4018c:9024941техническая документация на русском<p>Автор: Карл Рабелер (Carl Rabeler) Надлежащим образом построенные кубы, эффективные многомерные выражения</p> http://blogs.msdn.com/sqlcat/archive/2007/04/26/how-to-warm-up-the-analysis-services-data-cache-using-create-cache-statement.aspx#9440861Mon, 23 Feb 2009 06:02:35 GMT91d46819-8472-40ad-a661-2c78acb4018c:9440861Alexwei<p>AnalysisServices查询性能十大最佳实践 作者：CarlRabeler</p> <p>在针对SQLServer2005AnalysisServices实例进行MDX查询时，...</p>