We have an Analysis Services server that freezes from time to time (processor is sometimes very high, memory is high, and then we can not even stop the service - as if it went in an infinite loop).
I would like to know whether the following configuration overloads the service or not:
4Gb of RAM
SQL Server and Analysis Services installed on the machine
SQL Server limited to 1Gb of RAM
Analysis Services stay below 1.5Gb
Analysis services takes the rest
We have 102 cubes, some of them up to 100Mb
Apriori, is that configuration overloading the processor, or the problem is somewhere else?
102 cubes does sound a little extreme. I need to ask, are you running 2005 or 2000? Also are you running anything else on the box? SSRS?
B.
No comments:
Post a Comment