April 20, 2009 at 6:25 pm
We have the Analysis Service running and occasionally we get complain that the process timedout. Can anyone tell me what to check? This is SS2005. I am not sure where the problem could be.
TIA
April 22, 2009 at 11:46 am
Is the server overloaded when it times out? The disk I/O perhaps?
I'm not an SSAS person, but guessing here. I'd bet there is some other event on the server you can correlate to this.
Moving to SSAS forum.
May 28, 2009 at 12:19 am
Hi gk,
My hunch is that its not I/O related, but probably due to your source database contains a very large amount of data to be transferred to cube and causes the timeout. It probably happens if you're trying to process a cube that will run for more than an hour. MSAS cube by default will timeout after an hour.
What you should do is to set the MSAS properties to allow unlimited cube processing time, but bear in mind sometimes it might take i.e. a day to complete a cube processing, hence, eating up all the server resource especially CPU and slow down other apps.
You can change this setting by right-click MSAS instance > Properties and then click the check-box "Show Advanced (All) Properties" in the General tab. Look for a property Name "ExternalCommandTimeout" and ExternalConnectionTimeout" and set the Value to 0.
Please post again if this doesnt resolve your issue, unless you've moved this post somewhere else.
Simon
Simon Liew
Microsoft Certified Master: SQL Server 2008
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply