Optimizing & Analyzing DAX Query Plans

DAX is super-fast, you can use it to query billions of rows in less than one second. End of marketing, now let’s go back to the real world. If your query is not performing as advertised, it is time to dive into the details of optimizations, which means catching the query plan with the profiler, understanding what is happening under the cover and rephrase your query, or re-shape your model so to obtain better performance. In this live demo session, Alberto will start with a simple query and he will perform on stage all the necessary steps to optimize it, showing you the tools ant the techniques used to identify the bottleneck and to fix the performance issues. In the meantime, there will be chances to dive into some of the internals of the xVelocity query engine to  grab a better understanding of the optimization techniques in DAX.
Presented by Alberto Ferrari at SQLBits XII
  • Downloads
    Slide deck available Slide deck 4.3 MB
    Video available MP4 Video HD 558 MB
  • SpeakerBIO
    alberto_ferrari.jpg
    Alberto Ferrari is a Business Intelligence consultant. Alberto helped several software houses to build complex BI solutions, from the OLTP to the final OLAP cubes, providing planning hints all over the development lifecycle. He is a book author also, having worked on "Exper Cube Development with Microsoft SQL Server 2008" with Marco Russo and Chris Webb and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning with Marco Russo.
    http://sqlblog.com/blogs/alberto_ferrari/default.aspx http://sqlblog.com/blogs/alberto_ferrari/rss.aspx
  • Video