Clearing cache

Question

Is it possible to clear cache without restarting the SSAS service ?.

In AS2000 It was done by using the flushcache vbscript sample, but I didnt find a method similar to suspend/resume one, in AMO or xmla syntaxis.

Thanks

Leandro

Answer 1

I've just found a command in xmla for clearing cache:

<Command>
   <ClearCache>
      <Object>...</Object>
   </ClearCache>
</Command>

Thanks Leandro

Answer 2

You might find the 'ascmd' utility useful. It includes a sample for clearing the cache. The utility is part of the April 2006 updated Samples under Analysis Services \ Administration

Download here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en

_-_-_ Dave Wickert