Effective restart of SSAS

In SQL Server it is possible to do an effective restart by issuing

DBCC DROPCLEANBUFFERS -- Clears the data cache
DBCC FREEPROCCACHE -- Clears the procedure cache

which is really useful for performance testing.

Is there anything similar for SSAS?

thanks

Jamie

Hi Jamie

Sending the following XML/A command will clear the AS cache. You can run this from SSMS or send the string, by calling the Execute method on the server object in AMO.

<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>Adventure Works DW</DatabaseID>
</Object>
</ClearCache>

Cheers
Darren

|||

Top man Darren. Thanks very much!

-Jamie