Managing & Maintaining SSAS

SQL Server 2014    |    Expert
  • 10 videos | 1h 8m 4s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 11 users Rating 4.5 of 11 users (11)
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

  • 9m 34s
    In this video, learn how to optimize performance by changing the design of the cube or dimension. FREE ACCESS
  • 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 Business Analytics with SAS Studio: Deliver Business Intelligence by Combining SQL Processing, Insightful Visualizations, and Various Data Mining Techniques , First Edition
Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Journey Analyze Data with SQL
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Six Sigma Black Belt: Fundamentals of Lean and Six Sigma and their Applications
Rating 4.3 of 843 users Rating 4.3 of 843 users (843)
Course Data Warehousing & Business Intelligence Deployment
Rating 4.4 of 22 users Rating 4.4 of 22 users (22)
Course Report Formatting
Rating 4.3 of 7 users Rating 4.3 of 7 users (7)