Troubleshooting Analysis Services Performance Issues [BIA-206-HD]
Duration: 2.5 hours
Track: BI Platform Architecture, Development & Administration
Analysis Services performance problems can arise for a variety of reasons: poorly designed data model, lack (or improper use) of partitioning and aggregations, poorly written DAX/MDX calculations, etc. Unfortunately, many people have no idea where to start the troubleshooting process.
In this mini-workshop you'll learn how to identify the most common bottlenecks and performance issues and walk away with practical techniques (and scripts!) you can take home and start using immediately.
Your journey will start with learning how to think like the SSAS engine by seeing how a query is broken down into chunks and processed by the various subsystems. Along the way, you'll learn how to use (and automate) the collection of performance counters and extended events. By the end of the session, you'll not only know how to identify performance bottlenecks, but also how to narrow down the list of potential solutions.
Stop guessing what's causing your Analysis Services performance problems!