Microsoft SQL Server 2014: Manage, Maintain, and Troubleshoot SSAS


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
After the SQL Server Analysis Services or SSAS multidimensional models and the SSAS databases have been processed and deployed, it is important to ensure they remain up and running. Administrators need to run backups and administer the Analysis Services server to ensure it runs smoothly. This course will demonstrate how to process data models and deploy and administer the SSAS databases. It will also discuss and show how to performance tune, troubleshoot, and manage the SSAS server. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.

Target Audience
Business intelligence developers who create reporting and analysis solutions and individuals interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam

Prerequisites
None

Expected Duration (hours)
2.0

Lesson Objectives

Microsoft SQL Server 2014: Manage, Maintain, and Troubleshoot SSAS

  • start the course
  • optimize performance by changing the design of the cube or dimension
  • monitor SQL Server Analysis Services or SSAS using different performance counters
  • monitor SQL Server Analysis Services or SSAS using different Dynamic Management Views or DMVs
  • optimize Multidimensional Expressions or MDX queries using various methods
  • optimize Multidimensional Expressions or MDX queries in the calculations
  • monitor and clear the SQL Server Analysis Services or SSAS cache
  • use SQL Profiler to create a trace to troubleshoot SQL Server Analysis Services or SSAS issues
  • view error and events logs to troubleshoot SQL Server Analysis Services or SSAS instances
  • identify issues with incorrect relationships
  • identify issues with incorrect aggregations
  • create roles to implement SQL Server Analysis Services or SSAS database permissions
  • troubleshoot dynamic security issues in SQL Server Analysis Services or SSAS
  • prepare to backup a multidimensional database
  • backup a multidimensional database using the Backup window in SQL Server Management Studio or SSMS
  • backup a multidimensional database using PowerShell
  • restore a multidimensional database
  • process SQL Server Analysis Services or SSAS objects, deploy SSAS database, and manage an SSAS instance

    • Course Number:
    md_idmr_a07_it_enus

    Expertise Level
    Expert