Introduction
For performance testing and optimization, measuring the raw performance of a form refresh can be useful. You can measure by timing how long it takes to refresh the form from a cold start. However, to run this test accurately, you should clear your SSAS cache to get accurate results. This article shows you how to clear your SSAS cache.
Clear SSAS cache
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. Replace the DatabaseID with 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.