First let me give you a little background of why you would want to clear SSAS cache from C# code when you can do this using an XMLA command from SSMS. If you have a slow MDX/DAX SSAS query , you have a couple of options for improving the performance (assuming no hardware changes): Rewrite … Continue reading How to clear SSAS cache using C# for query performance tuning
Category: XMLA
Clear Cache XMLA for SSAS Multidimensional
I often use the following XMLA code to clear database/cube/measure group cache in SSAS Multidimensional when I do performance testing between different MDX queries or versions of the same database. I am posting it here so that I can find it easily in future. You can use it to clear the cache at the database, cube or … Continue reading Clear Cache XMLA for SSAS Multidimensional