I can't compare sp3 behavior to pre-sp3 behavior, but I did experience
similar problems (i.e. processing large dimensions that would just hang
without committing).

Increasing the Memory conservation threshold setting fixed the issue.

--
Posted via http://dbforums.com

I'll try. Many Thanks!

Gauss

Originally posted by mdxuser


--
Posted via http://dbforums.com

MDXUser, thanks, your comment fixed my problem. I ran into the same situation:

- A dimension (125K members) was processing fine in SP2 and it hung in SP3.
- In SP3, increased the conservation memory threshold from 1.0GB to 1.6GB and
the dimension processed fine in just one minute.

This still leaves some lingering questions:

1. If it just needed more memory, why was there no indication of it?

2. Does this behavior represent a bug in SP3?

Basically, I am wondering whether to rollback to SP2. I am not sure because
there is not sufficient evidence that something is wrong with SP3. I am
responsible for many instances of Analysis Services so it is a pretty
major decision for me. It also affects the future instances that I will
create soon. Any comment will be appreciated.

-Mike Shen


mdxuser <member32262 (AT) dbforums (DOT) com> wrote