I would like to have a few questions and a little discussion about the experience of users here.
we have 3 servers, where there are fews AG, and all work almost all the time well.
But sometimes, and we cannot find directly when and why, there are a lot of blocks and a lot of waiting with DTC and HADR_SYNC_COMMIT.
almost all the time we must to do failover on another node and it helps.
But we cannot find the direct reason.
Do you have any experience with this, any suggestions?