In this article, we will learn how to use a Powershell script to track the network latency issue in the AwlaysOn availability group (AOAG), the network latency may become a real issue for the AOAG, if the network latency is too high for AOAG, the primary replica will lose the connection to the secondary replica, it may cause the automatic failover in the AlwaysOn availability group. In this case, we use System Center Operation Manager (SCOM) to monitor our AOAG, and we found a strange thing, this automatic fault occurs regularly.
Fault phenomenon
We have a SQL Server AlwaysOn