Managing & Maintaining SSAS
SQL Server 2014
| Expert
- 10 Videos | 1h 8m 4s
- Includes Assessment
- Earns a Badge
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 dimensionmonitor SSAS using different performance countersmonitor SSAS using different Dynamic Management Views (DMVs)optimize MDX queries using various methodsoptimize MDX queries in the calculations
-
monitor and clear the SSAS cacheuse SQL Profiler to create a trace to troubleshoot SSAS issuesview error and events logs to troubleshoot SSAS instancesidentify issues with incorrect relationshipsidentify issues with incorrect aggregations
IN THIS COURSE
-
1.Optimizing Performance of Cubes and Dimensions9m 34sUP NEXT
-
2.Monitoring SSAS Using Performance Counters6m 37s
-
3.Using DMVs to Monitor SSAS6m 51s
-
4.Optimizing MDX Queries7m 25s
-
5.Optimizing MDX in Calculations8m 9s
-
6.Monitoring and Clearing the SSAS Cache4m 55s
-
7.Using SQL Profiler to Create Trace Files8m 23s
-
8.Viewing Error and Event Logs to Troubleshoot SSAS4m 25s
-
9.Identifying Issues with Relationships5m 36s
-
10.Identifying Issues with Aggregations6m 9s
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.