SQL AG 3servers and problem with DTC and HADR_SYNC_COMMIT

• tony28

  SSCertifiable

  Points: 7112

  More actions

  September 20, 2023 at 4:37 pm

  #4290477

  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

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  September 21, 2023 at 5:10 pm

  #4291196

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

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

• Summer90

  SSC-Dedicated

  Points: 32891

  More actions

  September 21, 2023 at 7:20 pm

  #4291284

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

• tzimie

  Old Hand

  Points: 321

  More actions

  October 4, 2023 at 7:43 am

  #4301062

  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