Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

MDX Tuning Webcast

leave a comment »

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.

Written by Chris Webb

June 21, 2005 at 10:47 am

Posted in On the internet

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,189 other followers

%d bloggers like this: