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.
- Downloads
- SpeakerBIO
Chris Webb is an independent consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase", and blogs at
http://cwebbbi.wordpress.com/
- Video
- Session Files Explorer
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.