SQL AG 3servers and problem with DTC and HADR_SYNC_COMMIT

  • Hello,

    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?


  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • We have the same issue after applying CU15 to one of our systems with several servers participating in a AG.

  • We had an isse when HADR was locked by user transactions and vice versa

    It happened soon after we upgraded from Standard edition to Enterprise and started to use Resource Gov.

    But after a while issue had dissapeared and I dont know why

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply