We have installed sql server 2008 (64 bit) on windows server 2008 enterprise edition, in which around 10 jobs to populate the dimensions from relational db to analysis cubes.
I am frequently facing the same error and the services gets stopped.
"The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s)."
when i try to restart the analysis services, in next few minutes the service gets disabled.I tried disabling the sql service and disabling the agent jobs which indicates the dawaflow will be stopped.
I have enough memory and cpu resources.
Can any one pour some inputs to solve the issue.