Performance Tuning MDX queries
You've built your cube and it's working well, but there's one important query which is taking hours to run. How can you tune it? This session will tell you how to diagnose the causes of poor query performance with Analysis Services 2005 and share some hints and tips on how to solve them by optimising your cube structure and writing efficient MDX.
Speaker focus
Chris Webb, has been working with Microsoft's Business Intelligence tools since 1998. He is a well-known figure in the Microsoft Business Intelligence community, regularly contributing to newsgroups and online discussion forums, and has spoken at several international conferences. He is a co-author of the second edition of the book "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase" along with George Spofford. His weblog can be found at http://spaces.msn.com/cwebbbi.
Chris has extensive experience of implementing Business Intelligence solutions on the Microsoft platform across a wide range of industries including pharmaceuticals, banking, engineering, manufacturing and market research. He has worked as a consultant (including three years with Microsoft Consulting Services) and as a permanent employee on internal development teams, and understands the different demands of each role.
Other sessions from this conference