SQLServer2019
I have configured Alwayson on SQLServer2019, Someone executed a query on the secondary replica. at the same time, the primary replica stopped synchronizing data to the secondary replica.
How to make sure my sync is not affected in any way? (I cannot guarantee that the secondary replica will not experience a deadlock)
I use Zabbix to monitor deadlocks on the secondary replica, and once a deadlock occurs, I execute the kill
New contributor
black is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.