Deep dive into Analysis Services

This session will go into details of how the Analysis Services engine works, giving guidance for tuning/optimizations as well as explanations of best practices and operations strategies.

It will be important for attendees to have pre-existing expertise with Analysis Services. It would be advantageous for them to also have knowledge of general operating systems concepts like memory allocation, threading, I/O, etc.
Presented by Akshai Mirchandani at SQLBits X
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Akshai is a long time developer with the Analysis Services team. He was a contributing member of the team that designed the XMLA protocol and implemented the XMLA SDK for Analysis Services 2000. Since then, he has helped to design, build and lead many different parts of the Analysis Services product including Proactive Caching, Dimension/Partition Processing, Block mode, NonEmpty in block mode, xVelocity integration into the Analysis Services engine, scale-up performance efforts, etc. He has also been heavily involved in building the content for the Maestros course ( and the Operations and Performance guides for Analysis Services.
  • Video
    The video is not available to view online.