Forum Discussion
Is it possible to do load balancing in a Standard Edition deployment?
- Nov 21, 2017
Hi Rob,
When using a Standard edition load balancing does nothing. If you want to load balance users between servers you will need to have enterpise edition with the minimal 3 front end servers. your SQL Database will be on separate servers.
For the Edge role you can create a new pool with 2 servers (this works in standard and enterprise edition) The pool can be a load balancer.
There is a lot of misunderstanding around this topic. In general, depending on your requirements you can do HA or DR.
In general, for midsize customer we have a reference architecture described here
https://technet.microsoft.com/en-us/library/gg398095(v=ocs.15).aspx
In general, if HA is NOT a requirement you could pair two STD in the same DC for failover. It's not HA in the essence of the word but could fulfil the requirement.
If HA (so POOL high avaibility is a requirement) than indeed as Erwin mentioned you need Enterprise Edition.
- Nov 23, 2017A little note on this setup, failover needs to be done by administrator manually.
- ivanjaNov 24, 2017
Microsoft
Powershell is your friend here :) But yes, a manual failover is the standard approach.