Recently, I was in a training course about the new features of 2005.
The trainer said that 2005 dealt with active/active memory differently
during a failover - as the secondary came online, it would start
taking more memory, and the primary would release memory. So, on my
two boxes with 16gb RAM, I allocated 10 for one node and 12 for the
other (before we were at 6 & 8). However, when we had a failover it
appeared that the secondary was going to take as much memory as it
could - I had less than 1gb available by the time we "rolled" the
secondary back to its original box.

But, that begs the question - was that advice incorrect? On an active-
active cluster on 2005, does the memory still need to be set to not
oversubscribe?

Thanks in advance.