PASS Summit 2010
Register Now

ROI Justification

Sponsors

Questions?

PASS Facebook PASS LinkedIn PASS Twitter


Premier Sponsor:
  

Platinum Sponsor:
  
MDX Query Performance Tuning
In order to get top performance from SSAS, it is necessary to have a good knowledge of the behavior of the internal engine of SSAS which copmutes MDX queries. Moreover, the design of the OLAP cube needs to follow some best practices in order to make the MDX query processor work best.

What can we do if an MDX query is slow? And, is it really slow or it is already working at its best? Is it able to scale well as the database size grows? From where do we start to analyze the performance of an OLAP cube? This sessions will give answers to all these questions, by performing a deep analysis of the internals of SSAS, partitioning, aggregation design and the analysis of events generated by SSAS during the query resolution. Moreover, we will describe cache usage, block computations and show some best practices on how to write efficient MDX queries that will make SSAS work at top performances.

Speaker Bio: Alberto Ferrari is a consultant and trainer in BI development in Italy. His main interests are in the methodological approaches to BI development. His thoughts about it are shown at http://www.sqlbi.eu/SqlBiMethodology.aspx where, with Marco Russo, they describe a complete methodological approach to BI development. He spent several years working with SSIS and SSAS for the banking and manufacturing industries. He normally works as a consultant for SW developers who are interested in the creation of complex BI solutions.

Session Goal #1: Learn basics of MDX compuation engine and detect MDX issues.

Session Goal #2: Learn usage of MDX Studio.

Session Goal #3: Learn advanced MDX tuning methodology.

(Please note: cannont click through to speaker details from speaker's name below)
Speaker:
SQLBI
Consultant
Alberto Ferrari is a consultant and trainer in BI development in Italy. His main interests are in the methodological approaches to BI development. His thoughts about it are shown at http://www.sqlbi.eu/SqlBiMethodology.aspx where, with Marco Russo, they describe a complete methodological approach to BI development. He spent several years working with SSIS and SSAS for the banking and manufacturing industries. He normally works as a consultant for SW developers who are interested in the creation of complex BI solutions.
Register Now for PASS Summit 2010!


 
  Top Reasons to Attend
PASS Summit 2010
  • Over 160 technical sessions from the world's top SQL Server and BI experts
  • 2 full days of deep-dive Pre- and Post-Conference Seminars
  • Networking with thousands of SQL Server MVPs, experts, Microsoft employees, and peers
  • Face-to-face support with the Microsoft CSS and SQLCAT teams
  • Ask the Experts Lounge
  • And much more!
 
 

Gold Sponsor

     
     
Copyright 2010 by PASS | Terms of Use | Privacy Statement