Performance investigations with Analysis Services 2012
This session will do a brief overview of Analysis Services 2012 performance topics, and drill into some common methods for investigating performance issues. The talk will be adjusted based on the audience interests.
The agenda includes:
- Tabular versus Multidimensional: a very brief overview
- Performance investigation tools: Profiler, XEvents, MDX, ETW
- Tuning Analysis Services for high end hardware
- Common pitfalls for processing performance
- Formula engine performance -- frequently asked questions/issues