Clearing standby cache (and other caches) in Analysis Services

Greg Galloway just released a new version of the Analysis Services Stored Procedure Project that includes a command to clear the File System Cache, including the standby cache.

A technical discussion about how it works is available in this post on his blog.

It is a great tool to have whenever you need to do performance measures with a real cold cache.
Kudos to Greg for his efforts! 


Article written by
Post originally appeared on:  sqlblog.com

 Enclose code in comments with <PRE></PRE> to preserve indentation.