Hello,

We are having tabular model cube which is of 40GB. Every day we are processing this cube via SSIS, before processing it we are restarting the SSAS service(from scripttask) so that it will clear memory and cache.
   But most of the time service restating is not happening properly and package is getting failed. Thereafter we need to start service manually and then again we need to run the package.

My question :

  Restarting SSAS service every day is really good practice ?

  Apart from restarting service what other approach is there? 

Awaiting for your reply!

Thanks and Regards,
Santhosh Shasthri M R

Hi Santhosh,

You can troubleshoot why service restating is not happening properly by using the msmdsrv.log. Are there any error message on the log? Under C:\Program Files\Microsoft SQL Server\MSAS11.\OLAP\Log (this could be different for your server), there are 3 log files that are generated:

• msmdrrv.log
• FlightRecorderCurrent.trc
• FightRecorderBack.trc

The msmdrrv.log simply points to the other two logs. There might be some detail information for this error.

Besides, I don't think you need to resrart the server to clear memory and cache. You can clear Analysis Services caches with SSIS task by using  XMLA command, and run this package before run package to process cube.
http://consultingblogs.emc.com/jamiethomson/archive/2006/07/07/SSAS_3A00_-Clearing-the-Analysis-Services-cache.aspx
http://technet.microsoft.com/en-us/library/hh230974.aspx

Regards,