January 19, 2021 at 3:39 pm
I've SQL 2017 Read Scale availability group setup in our test environment(AOAG configured on two stand alone instances with Readonly routing in Synchronous Commit).
Our app uses Read replica for reports and read queries. I've setup performance counters to measure the maximum latency for data loss(Transaction Delay and Mirrored write transactions/sec).
But I need to measure the maximum data latency, which includes hardening time for redo thread(time being taken for the data to actually appear in Read replica database). This is because of some of our reports executing on read replica needs the latest data from Primary.
Can anyone please help me with this.
January 20, 2021 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 26, 2021 at 2:03 am
Have you had a look at this? You can use the metrics on this page to create a formula to show you redo latency.
https://documentation.red-gate.com/sm9/analysis-graph/list-of-metrics
This also has some queries and formulas that may get you what you need.
https://www.sqlshack.com/measuring-availability-group-synchronization-lag/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply