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!