July 25, 2012 at 11:57 pm
Hi All
Within SQL Server Management Studio, under the management section, what is the Distributed Transaction Coordinator used for?
Does this only apply to Multiple Node clusters?
Can someone enlighten me on the topic of Distributed Transactions?
Thanks
July 27, 2012 at 6:03 am
This was removed by the editor as SPAM
July 28, 2012 at 2:56 am
The Distributed Transaction Coordinator (DTC) service coordinates transactions that update two or more transaction-protected resources, such as databases, message queues, files systems, and so on. These transaction-protected resources may be on a single computer or distributed across many networked computers.
Further, information listed on the following URLs will answer your question:
http://blogs.msdn.com/b/cindygross/archive/2010/10/18/do-i-need-dtc-for-my-sql-server.aspx
http://blogs.msdn.com/b/sqlblog/archive/2006/10/06/msdtc-and-sql-server-on-a-cluster.aspx
July 29, 2012 at 1:07 am
On a stand alone server Microsoft Distributed Transaction Coordinator (MSDTC) run as a normal service.
On a fail over cluster MSDTC has to be installed as a cluster resource. Up to Windows Server 2003 it can be assigned to the cluster group and use the quorum disk. From Windows Server 2008 upwards it has have it's own group and disk.
On a SQL Server 2012 availability group cluster, where SQL Server is installed as a stand alone instance on each node, MSDTC has to run as a normal service.
If you have multiple instances of SQL Server installed on a stand alone server or cluster you will have to have only one instance MSDTC per server or cluster.
Other services, like Microsoft Message Queues (MSMQ) and Microsoft BizTalk server, also require MSDTC.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply