Load balancing SQL application (NLB to achieve HA in Sql Server)



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.



0 Replies