configure MSDTC for sql always cluster

Question

from the pop up related question, it says MSDTC is not support with Alwayson, but dated 2013, so not accurate. Based on MS article, yes supported. https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-availability-group-for-distributed-transactions?view=sql-server-ver15
My question is do you configure DTC on each node or do you create a role in failover cluster like below for MSDTC?
Backed years ago, I configured both node and cluster (shared storage) MSDTC role for my SQL clusters, not really sure if we did need both.

Question2: does alter availability group DTC support causing AG availability interruption (like failover or downtime, sql 2016 sp2 cu15 on window 2019, article didn't say it?
ALTER AVAILABILITY GROUP MyaAG
SET (
DTC_SUPPORT = PER_DB
);

Answer 1

Hi @zhiqing zhou ,

Welcome to Microsoft Q&A!

My question is do you configure DTC on each node or do you create a role in failover cluster like below for MSDTC?

Please refer to this:
https://www.sqlshack.com/explore-cross-database-msdtc-for-distributed-transactions-in-sql-server-always-on-availability-groups/
The link contains some pictures could give you some ideas. Moreover, there are other related content at the end of the article which you can have a look. Sometimes, they can have a better explanation about the official document.

Question2: does alter availability group DTC support causing AG availability interruption (like failover or downtime, sql 2016 sp2 cu15 on window 2019, article didn't say it?

No. I did a test in my environment. I executed this statement, but it did not cause AG availability interruption

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.