Managing & Maintaining SSAS

SQL Server 2014    |    Expert
  • 10 Videos | 1h 8m 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
    FREE ACCESS
  • Locked
    4. 
    Optimizing MDX Queries
    7m 25s
    FREE ACCESS
  • Locked
    5. 
    Optimizing MDX in Calculations
    8m 9s
    FREE ACCESS
  • Locked
    6. 
    Monitoring and Clearing the SSAS Cache
    4m 55s
    FREE ACCESS
  • Locked
    7. 
    Using SQL Profiler to Create Trace Files
    8m 23s
    FREE ACCESS
  • Locked
    8. 
    Viewing Error and Event Logs to Troubleshoot SSAS
    4m 25s
    FREE ACCESS
  • Locked
    9. 
    Identifying Issues with Relationships
    5m 36s
    FREE ACCESS
  • Locked
    10. 
    Identifying Issues with Aggregations
    6m 9s
    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 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

BOOK SAS Visual Analytics for SAS Viya
CHANNEL SAS
Likes 64 Likes 64  
BOOK SAP Analytics Cloud