Book Image

Expert Cube Development with SSAS Multidimensional Models

Book Image

Expert Cube Development with SSAS Multidimensional Models

Overview of this book

Table of Contents (19 chapters)
Expert Cube Development with SSAS Multidimensional Models
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

MDX calculation performance


Optimizing the performance of the Storage Engine is relatively straightforward; you can diagnose performance problems easily and you only have two options – partitioning and aggregation – to solve them. Optimizing the performance of the Formula Engine is much more complicated because it requires knowledge of MDX, diagnosing performance problems is difficult because the internal workings of the Formula Engine are hard to follow, and solving the problem is reliant on knowing tips and tricks that may change from service pack to service pack.

Diagnosing Formula Engine performance problems

If you have a poorly performing query, and if you can rule out the Storage Engine as the cause of the problem, the issue is with the Formula Engine. We've already seen how we can use Profiler to check the performance of Query Subcube events, to see which partitions are being hit and to check whether aggregations are being used; if you subtract the sum of the durations of all the Query...