Can you please suggest if it is feasible to create a SQL 2017 3 node (2 nodes in same DC and 1 in different DC)HADR for Alwayson for say 40 high performing databases :
If we have a sync replication for alwayson for the 2 Instances in same DC , I understand there will be latency due to sync replication and will impact performance vs async however with async we will not be having automatic failover without data loss.
Is it recommended to use alwayson for 40 or so high performing databases or is a MS Cluster more preferable.