We have setup a 3 node AAG in our staging environment as a POC. The 3rd node has been configured in a different subnet and also as an asychronous replica. The Windows Server version is 2012 R2 and the SQL Server version is 2014 SP2. After I changed the availability mode to synchronous commit and tried to perform a manual failover across subnets, this is what I get. I had removed the node weight of the 3rd node. Am I missing something here? Please advice.
I had removed the node weight of the 3rd node. Am I missing something here?
You're receiving the informational message because you've removed the possible vote (node weight of 0) of the replica. Since it won't ever have a vote, it also won't ever be able to stand on its own should any issues arise with the cluster, since this effectively removed the dynamic quorum aspect of clustering when this node owns anything.
This truly may be what you want, for example as a DR node whose availability you don't want impacting the production nodes. In that case, as long as you understand the situations you're protecting against and meeting those then I don't see a problem setting it like this (which is effectively that you know better than the cluster).
