MDX Performance

SQL Server 2014    |    Expert
  • 9 videos | 55m 59s
  • Earns a Badge
Rating 4.6 of 11 users Rating 4.6 of 11 users (11)
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

  • 6m 44s
    In this video, you will learn how to use Data Collector to monitor a SQL Server instance by gathering performance-related data. FREE ACCESS
  • 6m 46s
    Learn how to use Performance Monitor to troubleshoot data warehouse performance issues. FREE ACCESS
  • Locked
    3.  Using Resource Governor to Balance Load Resources
    9m 56s
    In this video, find out how to use Resource Governor to balance resources for an ETL load process. FREE ACCESS
  • Locked
    4.  Using Performance Monitor to Troubleshoot SSAS
    4m 57s
    In this video, you will use Performance Monitor to troubleshoot performance for SSAS. FREE ACCESS
  • Locked
    5.  Using SQL Server Profiler to Monitor MDX Queries
    5m 12s
    Find out how to use SQL Server Profiler to analyze and optimize performance of MDX queries. FREE ACCESS
  • Locked
    6.  Using SQL Server Profiler to Monitor DAX Queries
    4m 15s
    In this video, you will learn how to use SQL Server Profiler to analyze and optimize the performance of DAX queries. FREE ACCESS
  • Locked
    7.  Using Performance Monitor to Monitor SSRS
    5m 47s
    To find out how to use Performance Monitor to monitor SSRS performance, consult the SSRS documentation. FREE ACCESS
  • Locked
    8.  Configuring Memory Setting for Reporting Services
    5m 58s
    In this video, you will learn how to configure memory settings for Reporting Services to ensure optimal performance. FREE ACCESS
  • Locked
    9.  Optimizing SSRS Performance Using Caching and Snapshots
    6m 24s
    In this video, find out how to configure caching for a report and monitor its effects using Performance Monitor. 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 SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis
Course Data Loading & Visualization in Power BI: Loading Data from Databases
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Book Database Performance at Scale: A Practical Guide

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course BI Project Deployment
Rating 4.5 of 23 users Rating 4.5 of 23 users (23)
Course Managing Reporting Services
Rating 4.4 of 11 users Rating 4.4 of 11 users (11)
Book Business Intelligence with SQL Server Reporting Services