Skip to Content
0
Former Member
Dec 16, 2009 at 01:32 PM

Slow performance with processing of dimensions in BPC7

214 Views

Hello all.

I've recently upgraded a solution from BPC5.1sp6 on SqlServer2000 to BPC7.0sp5 on SqlServer2008 (64 bit). The application set was moved by using Server Manager to take a backup in the old environment and restore in the new environment (followed by instructions mentioned in the upgrade guide). What puzzles me is that I experience a serious perfomance decrease. When I for instance try to process a dimension, it takes forever (pausing a long time in the step "Create dimension"). And to process the whole cube takes even longer. Also, some reports run normally, while others take much longer time to run.

I hope someone is able to help me with som new ideas to try out.

¨

Regards

Arild Bjørsvik.