Windows Failover Clustering - SQL Server - Latency on Connection

[H. Williams]

Hello,We've just set up a two-node Windows Failover cluster (WFSC) on Windows Server 2019 across AWS regions (Oregon and Ohio) using Sios DataKeeper to replicate the files. We installed two SQL 2017 instances on the cluster. We adjusted the heartbeat settings to be more forgiving of a multi-subnet config with 2 seconds instead of 1 on the cross-subnet settings. (We run 4 other clusters across AWS Availability Zones (AZ) with no problems, this is our first cross-region cluster.)There were no issues during setup. The two roles can easily move between the two hosts with no hesitation or error

Continue reading...