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
Clearing cache
Hot Topic
- code for the KPIs
- Problem Connecting To Reporting Services
- backuping logins + passwords.
- TSQL or CLR for a complex query?
- SSIS Requests...
- can't modify stored proc which is in a publication
- Creating a double entry book keeping system
- SSIS Foreach loop stress testing problem.
- SQL Server 2000 DTS Tools Web Download
- Merge replication with dynamic filter
SQL Server
- SQL Express with the WDK DTM?
- Sql manager
- Log Shipping Error
- How to open a SSIS solution with broken Data Sources in less than 20 minutes?
- Couldn't make Filter Option of Report to work
- SQL Server 2000 Backup to my Mac Server???
- Dealing with UDT - defined in SQL Server 2005 - within a C# application
- sqlmangr.exe program error (Please help)
- Accessing SQL Mobile Databases in VB2005 - Pocket PCApp
- FileSystem Deployment
Clearing cache
gogetsome
I've just found a command in xmla for clearing cache:
<Command>
<ClearCache>
<Object>...</Object>
</ClearCache>
</Command>
Thanks Leandro
djstates
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