Why Bytes Sent to Transport/sec is different on different replicas?
0
votes
0
answers
96
views
I am troubleshooting latency for a specific replica in a Distributed AG setup (with 2 remote replicas).
Looking at perfmon I see clear indication as to why one replica shows delay. I see Bytes Sent to Transport/sec is in sync with one replica (*Red & Purple lines*) - but not on the other. (*Green Line*).
I was wondering what could contribute to this behaviour. I checked there is no delay at Flow Control Gates.
Edit:
SQL Server Version is 2019 (CU22)
Answers to questions from comments:
- Is this for the same AG and a different distributed replica?
Different AGs?
> This is for one single AG only.
- Where are the replicas?
> All 3 distributed replicas are in different DCs across the globe. Each AG has 2 nodes (sync mode).
- Are the distributed replicas setup the same (sync/async)?
> Yes, both are ASYNC
- Is the hardware the same?
> YES
- Are all of the databases on the forwarder side ok?
> YES

Asked by GAURAV RATHOD
(186 rep)
Jan 24, 2024, 07:50 AM
Last activity: Jan 29, 2024, 05:07 AM
Last activity: Jan 29, 2024, 05:07 AM