Tuning SSAS Models

Focused View

Stacia Misner Varga

3:03:22

44 View

01 Course Overview

01 Course Overview.mp4

01:52

02 Monitoring Multidimensional Query Performance

02 Monitoring Multidimensional Query Performance.mp4

01:55

03 Multidimensional Query Architecture.mp4

03:11

04 Monitoring Tools.mp4

02:07

05 Demo Preparing and Executing a Trace.mp4

06:29

06 Demo Reviewing Events.mp4

04:21

07 Query Subcube.mp4

05:39

08 Performance Counters.mp4

04:40

09 Summary.mp4

01:33

03 Improving Multidimensional Query Performance

10 Improving Multidimensional Query Performance.mp4

01:39

11 Diagnostic Strategy.mp4

07:05

12 MDX Optimization Query scoped Calculations.mp4

05:13

13 MDX Optimization Partial Expressions.mp4

03:36

14 MDX Optimization Set Reduction.mp4

03:11

15 Cell by cell Evaluation vs Bulk Mode.mp4

06:03

16 Query Parallelism.mp4

03:30

17 Scale up Considerations.mp4

02:40

18 Summary.mp4

02:20

04 Improving Multidimensional Model Design for Performance

19 Improving Multidimensional Model Design for Performance.mp4

02:24

20 MDX Script Optimization.mp4

05:58

21 Dimension Design.mp4

02:49

22 Attribute Relationships and User Hierarchies.mp4

05:09

23 Parent child Hierarchies.mp4

04:47

24 Aggregation Usage.mp4

05:58

25 Optimizations for Better Aggregations.mp4

02:47

26 Other Aggregation Design Options.mp4

02:38

27 Partitioning.mp4

03:10

28 Cache Warming.mp4

02:57

29 Summary.mp4

02:45

05 Monitoring Tabular Query Performance

30 Monitoring Tabular Query Performance.mp4

01:51

31 Tabular Query Architecture.mp4

03:04

32 Monitoring Tools.mp4

01:32

33 Demo Preparing and Executing a Trace.mp4

04:40

34 DAX Query Plan.mp4

05:17

35 Performance Counters.mp4

01:46

36 Dynamic Management Views.mp4

02:20

37 Summary.mp4

01:36

06 Improving Tabular Query Performance

38 Improving Tabular Query Performance.mp4

01:29

39 Diagnostic Strategy.mp4

06:10

40 Storage Engine Bottlenecks Callbacks.mp4

05:57

41 Storage Engine Bottlenecks Inefficient Filtering.mp4

03:37

42 Storage Engine Bottlenecks Error Handling.mp4

01:46

43 Formula Engine Bottlenecks Materialization.mp4

02:08

44 Formula Engine Bottlenecks Column Arrangement.mp4

01:43

45 Formula Engine Bottlenecks Variables.mp4

01:59

46 Summary.mp4

02:22

07 Managing Tabular Memory

47 Managing Tabular Memory.mp4

01:35

48 Tabular Memory Model.mp4

02:43

49 Demo Baselining Tabular Processing Performance.mp4

05:50

50 Demo Performing ProcessData and ProcessRecalc.mp4

02:20

51 Memory Footprint Optimization.mp4

03:01

52 Demo Optimizing the Tabular Model.mp4

05:12

53 Demo Adding Encoding Hints.mp4

02:46

54 Summary.mp4

02:12

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Stacia Misner Varga

Instructor's Courses

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.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.