Sunday, February 12, 2012

Analysis Services Cube Processing Timing

We are currently using Analysis Services 2000 sp3 on Windows 2003 sp1. We have a large cube that is partitioned and is processed nightly using Parallel Processing utility.

It takes over 4 hours to process that cube, however if the processing is killed after first few minutes and then Olap server is restarted and the cube processing is restarted it only takes 55 minutes.

Has anybody encountered similar situation?

Thank you,

Alex

Looks like you are hitting a timing issue. Try changing number of partitions you process in parallel.

You can also try and upgrade to the latest service pack ( SP4 ).

If still doesn't help, please open a case with Customer Support.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment