Sample Header Ad - 728x90

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. enter image description here 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