Database Reference
In-Depth Information
Figure 31-4.
Mutli-instance cluster with one reserved passive node
Unfortunately, you cannot implement configurations with reserved passive nodes in the Standard Edition of SQL
Server, which supports two-node Failover Clusters only.
You should carefully plan multi-instance cluster configurations, assuming that multiple instances can end
up running on the same node. You should buy hardware that can handle the load, and set up the minimum and
maximum server memory for each instance on each node. It is better to set up the minimum server memory based on
a worst-case scenario assuming that multiple instances are running simultaneously. The maximum server memory
can be set up based on the best-case scenario, when there is only one instance running on the node.
■
remember to keep some memory reserved for the Os when you set up the sQl server maximum
memory settings.
Important
in sQl server versions prior to 2012, memory settings controlled the memory usage of the buffer pool only. you should
factor in non-buffer pool memory when you set the memory settings.
Dealing with CPU configuration is more challenging. You can set up an affinity mask for the different instances,
which restricts an instance from using some of the logical CPUs. However, it is not the best approach when you have
only one instance running on a node, and you would like to have as much CPU power available to the instance as
possible. It is better to use the Windows System Resource Manager or Windows System Center and throttle CPU
activity if needed.
