Managing & Maintaining SSAS

SQL Server 2014    |    Expert
  • 10 videos | 1h 8m 4s
  • Includes Assessment
  • Earns a Badge
Likes 15 Likes 15
Once up and running, the SQL Server Analysis Services (SSAS) multidimensional models and the SSAS databases must be maintained. Learn how to analyze and tune performance, and troubleshoot data analysis issues.

WHAT YOU WILL LEARN

  • optimize performance by changing the design of the cube or dimension
    monitor SSAS using different performance counters
    monitor SSAS using different Dynamic Management Views (DMVs)
    optimize MDX queries using various methods
    optimize MDX queries in the calculations
  • monitor and clear the SSAS cache
    use SQL Profiler to create a trace to troubleshoot SSAS issues
    view error and events logs to troubleshoot SSAS instances
    identify issues with incorrect relationships
    identify issues with incorrect aggregations

IN THIS COURSE

  • Playable
    1.  Optimizing Performance of Cubes and Dimensions
    9m 34s
    In this video, learn how to optimize performance by changing the design of the cube or dimension. FREE ACCESS
  • Playable
    2.  Monitoring SSAS Using Performance Counters
    6m 37s
    Learn how to monitor SSAS using different performance counters. FREE ACCESS
  • Locked
    3.  Using DMVs to Monitor SSAS
    6m 51s
    Find out how to monitor SSAS using different Dynamic Management Views (DMVs). FREE ACCESS
  • Locked
    4.  Optimizing MDX Queries
    7m 25s
    During this video, you will learn how to optimize MDX queries using various methods. FREE ACCESS
  • Locked
    5.  Optimizing MDX in Calculations
    8m 9s
    During this video, you will learn how to optimize MDX queries in your calculations. FREE ACCESS
  • Locked
    6.  Monitoring and Clearing the SSAS Cache
    4m 55s
    In this video, you will learn how to monitor and clear the SSAS cache. FREE ACCESS
  • Locked
    7.  Using SQL Profiler to Create Trace Files
    8m 23s
    Learn how to use SQL Profiler to create a trace to troubleshoot issues with SSAS. FREE ACCESS
  • Locked
    8.  Viewing Error and Event Logs to Troubleshoot SSAS
    4m 25s
    In this video, learn how to view error and event logs to troubleshoot SSAS instances. FREE ACCESS
  • Locked
    9.  Identifying Issues with Relationships
    5m 36s
    Find out how to identify issues with incorrect relationships. FREE ACCESS
  • Locked
    10.  Identifying Issues with Aggregations
    6m 9s
    Learn how to identify issues with incorrect aggregations. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book SAS Visual Analytics for SAS Viya
Course Microsoft Azure Fundamentals: Databases & Data Analytics
Likes 229 Likes 229  
Book Text as Data: Computational Methods of Understanding Written Expression Using SAS

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course BI Reporting & Analysis
Likes 100 Likes 100  
Course Data Flow Implementation & ETL
Likes 37 Likes 37  
Course SSIS Package Execution & Script Tasks
Likes 15 Likes 15