Managing & Maintaining SSAS

SQL Server 2014    |    Expert
  • 10 Videos | 1h 13m 4s
  • Includes Assessment
  • Earns a Badge
Likes 10 Likes 10
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
    UP NEXT
  • Playable
    2. 
    Monitoring SSAS Using Performance Counters
    6m 37s
  • Locked
    3. 
    Using DMVs to Monitor SSAS
    6m 51s
  • Locked
    4. 
    Optimizing MDX Queries
    7m 25s
  • Locked
    5. 
    Optimizing MDX in Calculations
    8m 9s
  • Locked
    6. 
    Monitoring and Clearing the SSAS Cache
    4m 55s
  • Locked
    7. 
    Using SQL Profiler to Create Trace Files
    8m 23s
  • Locked
    8. 
    Viewing Error and Event Logs to Troubleshoot SSAS
    4m 25s
  • Locked
    9. 
    Identifying Issues with Relationships
    5m 36s
  • Locked
    10. 
    Identifying Issues with Aggregations
    6m 9s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE