{"id":219,"date":"2011-11-15T13:55:13","date_gmt":"2011-11-15T20:55:13","guid":{"rendered":"http:\/\/www.sqldbpros.com\/?p=219"},"modified":"2011-11-15T13:55:13","modified_gmt":"2011-11-15T20:55:13","slug":"clearing-the-sql-server-analysis-services-cache","status":"publish","type":"post","link":"http:\/\/sqldbpros.com\/wordpress\/2011\/11\/clearing-the-sql-server-analysis-services-cache\/","title":{"rendered":"Clearing the SQL Server Analysis Services Cache"},"content":{"rendered":"<p>Preparing to do some MDX performance testing?\u00a0 Step one for each and every test\u00a0should be to clear the cache.\u00a0 This will ensure you are seeing the performance results without the benefit of having data already loaded up in memory.\u00a0 How do you empty the MS SQL Analysis Services cache prior to running your query?<!--more-->\u00a0 Execute the following XML in a SQL Server Management Studio window:<\/p>\n<blockquote>\n<pre>&lt;Batch xmlns=\"<a href=\"http:\/\/schemas.microsoft.com\/analysisservices\/2003\/engine\">http:\/\/schemas.microsoft.com\/analysisservices\/2003\/engine<\/a>\"&gt;\r\n\u00a0\u00a0\u00a0\u00a0 &lt;ClearCache&gt;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &lt;Object&gt;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &lt;DatabaseID&gt;Your Database Goes here &lt;\/DatabaseID&gt;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &lt;\/Object&gt;\r\n\u00a0\u00a0\u00a0\u00a0 &lt;\/ClearCache&gt;\r\n&lt;\/Batch&gt;<\/pre>\n<\/blockquote>\n<p>Thanks to\u00a0<a href=\"http:\/\/www.bidn.com\/people\/DustinRyan\">Dustin Ryan<\/a> at\u00a0<a href=\"http:\/\/www.bidn.com\/blogs\/DustinRyan\/ssis\/1159\/clear-ssas-server-query-cache-for-mdx-query-performance-testing\">bidn.com<\/a>\u00a0for this tip!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Preparing to do some MDX performance testing?\u00a0 Step one for each and every test\u00a0should be to clear the cache.\u00a0 This will ensure you are seeing the performance results without the benefit of having data already loaded up in memory.\u00a0 How do you empty the MS SQL Analysis Services cache prior to running your query?<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44,22,45,43,8],"tags":[35,20,34,172,10,4,9,11,5],"class_list":["post-219","post","type-post","status-publish","format-standard","hentry","category-analysis-services","category-businss-intelligence","category-mdx","category-microsoft-sql-server","category-performance-tuning","tag-best-practice","tag-business-intelligence","tag-development","tag-mdx","tag-ms-sql","tag-performance","tag-sql-server","tag-sql-server-2008","tag-tips"],"_links":{"self":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/comments?post=219"}],"version-history":[{"count":4,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/219\/revisions"}],"predecessor-version":[{"id":223,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/219\/revisions\/223"}],"wp:attachment":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/media?parent=219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/categories?post=219"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/tags?post=219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}