Clear SSAS Cache with XMLA

Author: Kepion Product Team

Introduction

For performance testing and optimization, it's useful to measure the raw performance of a Form refresh (how long it takes to refresh the Form from a cold start). To do this, you need to ensure the SSAS cache is clear before you measure any response times. We will show you how to clear your SSAS cache, in this article. 

Example

1. Open SQL Server Management Studio and connect to your Analysis Server.

2. Expand Databases.

3. Right-click your target database and select New Query > XMLA.

4. Copy and paste the following code into the query. Change the DatabaseID to your database name.

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ClearCache>
      <Object>
         <DatabaseID>Solution-Integrated Planning</DatabaseID>
      </Object>
   </ClearCache>
</Batch>

5. Select Execute to run the query.