Sign up
SQLBits 2012

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.

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 Q&A

Speaker

Akshai Mirchandani

Akshai is a long time developer with the Analysis Services team. He has worked in various engine areas like MOLAP/ROLAP processing/queries, Proactive Caching, Formula Engine, VertiPaq, XMLA, transactions, etc. He has also been heavily involved in building the content for the Maestros course (http://blogs.msdn.com/b/sqlcat/archive/2011/01/31/what-is-the-ssas-maestros.aspx) and the Operations and Performance guides for Analysis Services.

Akshai Mirchandani's Sessions

Performance investigations with Analysis Services 2012