Currently planning on building a new SQL Server Cluster enviroment, we currently have 2 node 2 instance Active/Active cluster.

One of the clusters has had heavy hitting security/monitoring apps and also they've put user facing toolsets on there too.

Would it be possible have a Active/Active/Active 3 node 3 Instance Cluster? So each Instance was on its own node?

We had suggested Active/Active/Passive but one of the requirements from the client was each instance is active on its own node


Points to note:

  • A 3 node cluster requires SQL Server Enterprise Edition. You can deploy a 2 node cluster using Standard Edition.
  • If you are placing an active instance on each node, then each node will need to be licensed. That is 4 cores per node as a minimum so at least 12 SQL Server Enterprise Edition core licenses, possibly more if your load requires it.
  • You need to thoroughly test performance with all instances running on one node. If you lose two nodes and all instances fail over to a single node, can your hardware cope with the load?
| improve this answer | |
  • Thanks Andy, So currently they've got an Active/Active Cluster on 2 physical nodes running Enterprise Edition. The new cluster will be three physical nodes, with 2 cpu's, 4 cores each and 96gb ram per node. Regarding licenses they have an EA which covers them for 46 cores to be licensed under Enterprise Edition. – bsingh Nov 1 '16 at 16:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.