OLAP hung on Cube Full Process: Building indexes for the <Measure Group Name> partition has started.
-
OLAP hung on Cube Full Process: Building indexes for the partition has started. Observation: a. Cube Size - if my Date dimension contains only say 5 or 10 days of history, then this problem goes away. If I build the cube with say 25-35 days of history, then Cube Full Process hung on above statement (and CPU goes flat/zero afterwards) b. When put Analysis Service on SQL Profiler,
Building indexes for the <Measure Group Name> partition has started.
is the last statement captured on profiler but after which CPU goes flat and nothing seems to be happenning (no error/warning captured) c. Even if server has more physical memory, Analysis Service does not take all the memory available (It's configured to use 80% of avail memory)[^] Any idea? Thanks
dev
-
OLAP hung on Cube Full Process: Building indexes for the partition has started. Observation: a. Cube Size - if my Date dimension contains only say 5 or 10 days of history, then this problem goes away. If I build the cube with say 25-35 days of history, then Cube Full Process hung on above statement (and CPU goes flat/zero afterwards) b. When put Analysis Service on SQL Profiler,
Building indexes for the <Measure Group Name> partition has started.
is the last statement captured on profiler but after which CPU goes flat and nothing seems to be happenning (no error/warning captured) c. Even if server has more physical memory, Analysis Service does not take all the memory available (It's configured to use 80% of avail memory)[^] Any idea? Thanks
dev
What OS is it, and how much memory do you have on the server?
Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln