Lance England

Data | Analysis | Integration | Automation

SSAS Clear Cache snippet

So, this code snippet is all over the internet, but sometimes I just want to know where I can find it without asking Uncle Google every time.

This XMLA code snippet is for clearing the SSAS cache for performance tuning.

<ClearCache xmlns='http://schemas.microsoft.com/analysisservices/2003/engine'>
  <Object>
  <DatabaseID>your database ID here</DatabaseID>
  </Object>
</ClearCache>