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.
Learning Objectives
Analyzing Performance
- 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
Troubleshooting Data Analysis Issues
- 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
Managing SSAS
- 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
Practice: Deploy, Process, and Manage SSAS
- process SQL Server Analysis Services or SSAS objects, deploy SSAS database, and manage an SSAS instance