March 15, 2016 at 2:57 am
Hi,
I have an always-on AG that has 2 replicas. So ServerA(primary) has ServerB and ServerC as replicas.
ServerA and ServerB are in the same data center and ServerC is on a remote data center.
However, Since ServerC is on a different data center, we face latencies due to bandwith issues in network. We are working on that on a separate issue with the network folks.
So say for some reason, we have huge logs at a time where lot of inserts happen on ServerA, we see ServerB catch up in 2-3 minutes while serverC takes 1 hour or so.
So We have set ServerC only as a DR and ServerB for reporting.
I have created policies that alerts me if the estimated data loss exceeds 30 minutes. However we get alerted if the threshold is exceeded for either of the replicas.
I want to be alerted for just the latency on ServerB. Is there a way?
"Database Replica State" facet has been used to create the policy and condition expression @EstimatedDataLoss < 1800
Regards,
SQL Learner
March 15, 2016 at 3:41 am
Forgot to mention that I have set up an async commit mode till we fix the latency with cross data center replication.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply