I have two SQL Servers 2014 in AlwaysOn AG setup (OS - WSFC2012R2) with secondary acting as a synchronous replica. I'm facing an issue in the role switchover on daily basis.
Every day morning around 7 or 8AM, due to some reason Primary fails over to the secondary. Ideally, this happens due to network glitch. But i'm unable to find the root cause behind this failover.
This happens on daily basis. Is there any way to narrow down the issue which causes the failover?