Aggregation Processing Use of All Processors Issue

In 2000 when MSAS wanted to create aggs it did a great job without me doing anything of using all available processors pretty darn near or at 100%. In SSAS 2005 I have an 8-processor box (4 dual cores actually) and its only using 1 of the 8. Anyone know how to unlock that? Some property perhaps?

If you split the cube into several partions by using dates, AS2005 will use more than one processor.

Regards

/Thomas

|||

Based on 8 processors I used 8 partitions and it did better, but not much. Then I tried 16 partitions (many programs use 4X threads per processor to maximize parellelization, but if something is well written 1x should be sufficient) and I think it helped - utilization is up to 30 or 40 percent during the cube process part, but the aggregation part is still pretty low - 20-30% overall.

How many procs do you have and what utilization are you seeing during agg processing?

|||

The cubes I work with are small and they run on a four CPU box. By using partitions I was able to reduce the the processing time by 50 percent for one of the cubes.

I have not measured utilization, only processing time.

You will have to consider your I/O system as well and memory setting for SSAS2005. Maybe your low utilization depends on bottlenecks in memory or I/O?

Regards

Thomas