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