LightheartAl avatar image
LightheartAl asked

DTC - Active/Active Win2008R2/SQL2008R2 cluster

Setting up my first Win2008R2SP1/SQL2008R2SP1 Active/Active 2-server cluster. I would think that DTC needs to be active on both servers simultaneously? I haven't been able to find any article that simply describes how, how many, DTC resources(services≈ps) need to be set up (with associated 1GB drives presumably). I'm guessing that each server would need an Active DTC service present to service the Active SQL instance(s) on that server. Is that true? If Server1 hosts Instance1 actively, and DTC, and Server2 hosts Instance2 (and 3) actively, wouldn't there need to be a DTC1 active on Server1 and a DTC2 active on Server2? (If true presumably each DTC would need its own disk resource?) Al
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Sacred Jewel avatar image
Sacred Jewel answered
I would definitely recommend to install MSDTC but I don't think it is complusory. I also recommend that you create multiple DTCs, to unleash the powers of Win2k8 R2, using the following steps: 1. Create multiple cluster groups in the failover cluster. 2. Create a clustered MS DTC resource for each group. To fully exploit the processing power of the cluster, you must create as many groups as there are nodes in the cluster and evenly distribute the group to the nodes. Some of the benefits of such methodology are (From BOL) - Failure of one clustered application does not necessarily affect other clustered applications. In Windows Server 2008, you can create one DTC for each cluster group. This makes it possible for you to have disparate applications that each run with their own MS DTC resources on each node in the cluster. - There are no limitations on configuration ordering for the clustered MS DTC resource. Because it is possible in Windows Server 2008 to have a DTC running on each node, some problems, such as installation of COM+ applications and cluster configuration ordering, are no longer an issue. The virtualization layer for the Distributed Transaction Coordinator service (MSDTC) in Windows Server 2008 supports the running of multiple instances of Msdtc.exe. You do not have to use the same transaction coordinator if the original instance becomes unavailable. This makes it possible for you to use the local DTC on each node in a cluster for applications that do not require that clustering to meet availability needs. - Better application performance is possible. Because clustered applications can now have a clustered MS DTC resource that is located close to them, earlier performance issues with latency are mitigated Two very good related articles mentioned for more help [Understanding MS DTC Resources in Windows Server 2008 Failover Clusters][1] [How to Configure Multiple Instances of Distributed Transaction Coordinator (DTC) on a Windows Server Failover Cluster 2008][2] [1]: [2]:
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.