Tuning SSAS Models
This course explains the tools and techniques that you need to diagnose why multidimensional and tabular queries might be performing slowly and demonstrates the actions you can take to improve query performance.
What you'll learn
When you have users complaining about slow multidimensional and tabular queries, you need to know how to determine where the cause of the problem lies. In this course, Tuning SSAS Models, you will gain the ability to diagnose the source of query performance problems and apply the appropriate techniques to resolve those problems. First, you will discover how to determine whether the query bottleneck is in the formula engine or the storage engine. Next, you will learn whether you need to rewrite queries or modify the multidimensional or tabular model to resolve the query bottleneck. Finally, you will explore how to optimize tabular models for better memory management for query performance - and as a side benefit, this optimization will also benefit processing performance. When you are finished with this course, you will have the skills and knowledge of tuning Analysis Services needed to get the best query performance possible.
Table of contents
- Improving Multidimensional Model Design for Performance 2m
- MDX Script Optimization 6m
- Dimension Design 3m
- Attribute Relationships and User Hierarchies 5m
- Parent-child Hierarchies 5m
- Aggregation Usage 6m
- Optimizations for Better Aggregations 3m
- Other Aggregation Design Options 3m
- Partitioning 3m
- Cache Warming 3m
- Summary 3m
- Improving Tabular Query Performance 1m
- Diagnostic Strategy 6m
- Storage Engine Bottlenecks: Callbacks 6m
- Storage Engine Bottlenecks: Inefficient Filtering 4m
- Storage Engine Bottlenecks: Error Handling 2m
- Formula Engine Bottlenecks: Materialization 2m
- Formula Engine Bottlenecks: Column Arrangement 2m
- Formula Engine Bottlenecks: Variables 2m
- Summary 2m
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.