ach server in the cluster is still an independent server; configuration is
done the same way as a stand alone server. However, you need to configure
with the understanding that both instances MAY have to operate on the same
So if the box has 8 GB of memory, then you don't assign all 8 GBs to the
default instance on that box. If you did, when there is a failover, there
will be no memory for the 'visiting' instance.
If InstanceA has a minimum memory of 4 GB, and Instance B also has a minimum
memory allocation of 4 GB, and the server only has 8 GB, then upon failover,
the 'visiting' instance will be memory starved and will most like not come
online. (You have to make sure that there is enough memory for the OS as
Let's say both boxes have 8 GB. InstanceA contains large, heavily used
databases, so it is allocated 5 GB as a maximum, and InstanceB is less
demanding, so it is allocated 2 GB as a maximum. Upon failover, the two
instances require 7 GB, and leave 1 GB for the OS and memory management.
'Bean counters' will complain since it appears that InstanceB only needs 3
GB for the server, and adding an addition 5 GB is seen as a waste. However,
you have to consider the cost of the 'unused' 5 GB on InstanceB as insurance
payments for future availability. (And the same for the 'unused' 2 GB on
Thing to remember with configuration, is that upon failover, all instances
must be able to work (albeit perhaps not performing quite as well) on one
box. Most Server wide configuration settings 'should' be the same. Memory is
the most common setting that is different between Instances.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
You can't help someone get up a hill without getting a little closer to the
- H. Norman Schwarzkopf
"burt_king" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...