PASS Summit 2010
Register Now

ROI Justification



PASS Facebook PASS LinkedIn PASS Twitter

Premier Sponsor:

Platinum Sponsor:
Avoid Slow SSAS Queries: MDX Query Troubleshooting
Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often challenging because the level of support provided by the tools and the Analysis Services engine is not as mature as that found in the relational engine. This session covers the methods for examining slow queries using the SQL Profiler and Performance Monitor to determine the need for aggregations, caching problems, memory constraints, and so forth. Best practices for optimizing MDX will be examined, and various server properties will be discussed as necessary to help correct query issues. Attendees will leave armed with a practical approach to locating bottlenecks and strategies for speeding up queries.
Solid Quality Mentors
Craig Utley is a SQL Server MVP, a Mentor with Solid Quality Mentors and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT) where he focused on Business Intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0. Since then he has consulted at a variety of businesses worldwide on their BI solutions as an independent consultant, a ProClarity consultant, and a member of SQLCAT. In his time on SQLCAT, Craig saw some of the largest Microsoft data warehouses in the world and worked directly with the Analysis Services development team. He is the author of over 35 articles and 3 books, the most recent of which is about PerformancePoint Server 2007.
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