Environment details: SQL Server 2019 (CU 19) - 96 logical processors, 1.5 TB RAM Hosting 1 database of 3 TB
I have distributed availability group (async) setup which spans across two datacenters. Both sides (Primary and Forwarder AGs) are 2 node cluster with sync replica.
Everything is running smooth all day but sometimes I see huge log_send_queue_size (upto 7 GB). It clears up in couple of minutes at good rate, so I don’t suspect bandwidth to be bottleneck here.
What I am trying to figure out is what is generating so much log. And what should I use to track it (Extended events may be?). Any help would be appreciated.