Forum Discussion
SQL 2019 Enterprise Cluster setup
Hey Guys, I'm in the process of setting up Always on HA cluster on SQL 2019 Enterprise on virtual environment. Cluster will include SQL server instance on two separate Virtual machines with High a...
Only one node (primary) is writable.
The secondary is either readable or not readable.
If secondary is readable and you use it to shift some load from primary (some applications use ApplicationIntent=ReadOnly; in connection strings) - you need the second license.
Asynchronous / Synchronous affects possible data loss during failover; it is not relevant to licensing.
Synchronous-commit mode emphasizes high availability over performance, at the cost of increased transaction latency. Under synchronous-commit mode, transactions wait to send the transaction confirmation to the client until the secondary replica has hardened the log to disk.
The secondary is either readable or not readable.
If secondary is readable and you use it to shift some load from primary (some applications use ApplicationIntent=ReadOnly; in connection strings) - you need the second license.
Asynchronous / Synchronous affects possible data loss during failover; it is not relevant to licensing.
Synchronous-commit mode emphasizes high availability over performance, at the cost of increased transaction latency. Under synchronous-commit mode, transactions wait to send the transaction confirmation to the client until the secondary replica has hardened the log to disk.