| ktrock 2006-03-24, 8:26 pm |
| We have a clustered enivronment on 2 SQL Servers that are 64bit itaniums. We
had similar problems where Analysis Manager would hang and we would have to
failover the Analysis Server; which would work for awhile. We eventually
worked out that the problem was the underlying query was not joining all
tables and therefore trying to return millions of rows. This was under ROLAP
storage. There is a problem using ROLAP on itanium machines I think. We
haven't had the problem since converting to MOLAP.
Hope this helps,
Ken
"OLAP User" wrote:
> Ours is a clustered environment. The analysis server is online in passive
> node and SQL server is online in active node. We have about 30 cubes and we
> are facing some major problem with our anlaysis server for quite sometime
> now. We are not able to save changes to the cube or create a new cube. the
> analysis manger goes to not responding state and task manager shows nil
> resource utilization. recycling the analysis services from cluadmin didn't
> help. restarting both nodes of the cluster resolves the issue. but then not
> for too long. within a couple of days the problem starts again.
>
> We are not sure of the root cause of the issue. and do not know the solution
> too. We are in need of urgent help. do any of you have any suggestions?
>
|