Posts Tagged 'Load Balancing'

Why is allocation always selecting the same machine?

By powerpivotgeek (, on June 14th, 2010

If you are running PowerPivot for SharePoint on more than one backend app server, then it is a common issue that folks are seeing only one server being used. It turns out that this might be ‘by-design’ so let’s talk about it for a bit. Let’s look at the two allocation methods we support:

  • Round-Robin
  • Health-Based

Please click to continue reading.


A Peek Inside: Allocation. What is it? Why is it important?

By powerpivotgeek (, on April 2nd, 2010

Recently I have been getting some questions about an earlier post that I did around how the PowerPivot inactivity unloading is done. see for more details. Surely there must be a faster mechanism for unloading data – and there is – but to fully discuss that aspect of the system we need to take a step back and talk about how databases get loaded in the first place. I don’t mean the actual loading process (that is another interesting post that I’ll do later on), what I mean is how PowerPivot decides to load something to begin with . . . and where it decides to load it.

Read more…

Denny Lee’s Tweets (1/2 of PowerPivot Twins!)


Copyright © 2010 Denny G Lee - All Rights Reserved