MDX Performance

SQL Server 2014
  • 9 Videos | 58m 29s
  • Earns a Badge
Likes 7 Likes 7
You must monitor performance and security to ensure a BI solution is operating efficiently. Discover how to achieve this for the SQL Server instances being used, including SSAS, the data warehouse, and SSRS.

WHAT YOU WILL LEARN

  • use Data Collector to monitor a SQL Server instance by gathering performance-related data
    use Performance Monitor to troubleshoot data warehouse performance issues
    use Resource Governor to balance load resources for an ETL load process
    use Performance Monitor to troubleshoot SSAS performance
    use SQL Server Profiler to analyze and optimize performance of MDX queries
  • use SQL Server Profiler to analyze and optimize performance of DAX queries
    use Performance Monitor to monitor SSRS performance
    configure memory settings for Reporting Services to ensure optimal performance
    configure caching for a report and monitor its affects using Performance Monitor

IN THIS COURSE

  • Playable
    1. 
    Using Data Collector to Gather Performance Data
    6m 44s
    UP NEXT
  • Playable
    2. 
    Monitoring a Data Warehouse Using Performance Monitor
    6m 46s
  • Locked
    3. 
    Using Resource Governor to Balance Load Resources
    9m 56s
  • Locked
    4. 
    Using Performance Monitor to Troubleshoot SSAS
    4m 57s
  • Locked
    5. 
    Using SQL Server Profiler to Monitor MDX Queries
    5m 12s
  • Locked
    6. 
    Using SQL Server Profiler to Monitor DAX Queries
    4m 15s
  • Locked
    7. 
    Using Performance Monitor to Monitor SSRS
    5m 47s
  • Locked
    8. 
    Configuring Memory Setting for Reporting Services
    5m 58s
  • Locked
    9. 
    Optimizing SSRS Performance Using Caching and Snapshots
    6m 24s

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

Likes 17 Likes 17  
Likes 8 Likes 8  
Likes 4 Likes 4  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 78 Likes 78  
Likes 52 Likes 52  
Likes 267 Likes 267