Posts Tagged 'Load Balancing'

Why is allocation always selecting the same machine?

By powerpivotgeek (dwickert@microsoft.com), 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.

Advertisements

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

By powerpivotgeek (dwickert@hotmail.com), 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 http://powerpivotgeek.com/2010/03/04/a-peek-inside-unloading-powerpivot-data/ 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…