Hi
I have a scenario where in I have 3 Domain machines (Node1, 2 and Node3) and have SQL server 2017 installed on them.
Now, i want to achieve HA for my web or C# application I want to design a solution that whenever First request will go Node 1 and second request go node2 also if one machine goes down automatically other take over it.
Kindly advise is there any solution available?
I check some alternative option SQL Always on group (Enterprise lic require) and Sql Mirroring but we face some few disadvantages.
Regards,
Abubakkar
