MDX Tuning Webcast

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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: