MSDTC in sql server

Question

MSDTC in sql server

Chirag Sachdeva 281

Hi All,

I am tired after googling so much about local MSDTC and clustered MSDTC.

I have few queries regarding MSDTC in SQL Server Cluster.

If post windows 2008, we can use local DTC then why there is a need for clustered DTC?
In clustered DTC, do we need to create DTC role for each node in the cluster? if yes then how to create?
What is MSDTC mapping and when it is required?

Kindly help

Thanks

CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2022-03-28T07:04:31.91+00:00

Hi @Chirag Sachdeva ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know.

2 answers

Your answer

CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2022-03-28T07:04:31.91+00:00

Hi @Chirag Sachdeva ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know.

Answer 1

CathyJi-MSFT 22,396 Microsoft External Staff

Hi @Chirag Sachdeva ,

> If post windows 2008, we can use local DTC then why there is a need for clustered DTC?

With Windows 2008 Failover cluster and later you do not need to cluster MSDTC to utilize the functionality of the MSDTC service. This is because MSDTC was re-designed in Windows 2008 and unlike Windows 2003 if Windows Failover Cluster was installed you had to cluster MSDTC. This is no longer the case when using Windows 2008, since by default MSDTC service is running locally, even with Failover Clustering installed.

Currently there is some documentation that states you need to have a MSDTC Resource in your cluster.
I want to start out by emphasizing that the statement "You must install MSDTC is not 100 percent accurate." The statement does not take into account the OS and the changes with MSDTC in Windows 2008 and later.

For others two question, I suggest you reading this MS blog MSDTC Recommendations on SQL Failover Cluster, you can get the answers from this blog. This blog list common questions with MSDTC (Microsoft Distributed Transaction Coordinator) when used with SQL Server Failover Clustered instances to include current recommendations and best practices.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Chirag Sachdeva 281 Reputation points

2022-03-30T08:37:57.447+00:00

Thanks for your reply but still it is not clear.
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2022-03-30T08:40:08.593+00:00

Did you still have some confuse for question 2 and question 3?
Chirag Sachdeva 281 Reputation points

2022-03-30T13:51:32.6+00:00

Yes I am still unable to understand the need of clustered DTC when local dtc can be configured in clustering

If for some reason clustered dtc is required for clustering then, does each cluster node need its own role (So if there are 3 nodes then 3 clustered DTC roles would be there)?

Question 3 is also still unanswered What is MSDTC mapping and when it is required?

Answer 2

You do not need to do anything with MSDTC if you are using SQL Server 2008+ and Windows 2008+. This is all handled during installation on your cluster automatically.

https://techcommunity.microsoft.com/t5/sql-server-support-blog/msdtc-recommendations-on-sql-failover-cluster/ba-p/318037

Again I want to put emphasis on the fact that for Windows Server 2008 and later it is NOT required to cluster MSDTC to utilize the features of the MSDTC service.

Are you having a problem with MSDTC in your clustered environment?

Share via

MSDTC in sql server

2 answers

Your answer