Report Portal

Tuning Analysis Services (SSAS) for better Parallel Aggregation/Index Processing

One of the key performance concepts in Analysis Services is the design and use of good Aggregations to support user queries. However, Analysis Services (Both 2005 and 2008) by default is not configured very well to take advantage of multi-processor environments for parallel processing of these indexes, particularly for large MOLAP partitions. Keep in mind, using a large portion of available processors for aggregation building is only desirable in environments where a processing window is allocated and user activity is minimized or prevented entirely for that window...

Read more...

Tags: performance, xmla

 

2007-2015 VidasSoft Systems Inc.