I’ve just come across this new webcast on MDX tuning, covering the following topics:
- Non Empty Behavior property
- Remoting queries using Execution Location=3;Default Isolation Mode=1
- Cache Policy=7
- Cache Ratio and Cache Ratio2
- Cache Warming
Even though it’s only 20 minutes long, it is very, very useful. It contains lots of detailed information on how each of these optimisation tricks works, some of which I’ve never seen discussed publicly before.
My only grumble is why this stuff hasn’t been released before! Some of this functionality has been around for a few years now and yet it has never been documented properly. This stuff should be included in KB articles whenever a service pack is released.