msdtc and 2008 clustering
-
I had a problem today on my 2008r2 enterprise cluster. The network connectivity failed on the active node. It recovered but now msdtc cannot communicate with the sql instance. I do have a multi instance cluster - the second instance (which is communicating with msdtc) is on the other node
From what I am reading it seems that msdtc is only used if your app uses distributed queries (i.e begin distributed transaction). My question is what is the use of msdtc on a cluster if I don't have any distributed queries in my app?
-
a clustered dtc is no longer mandatory for sql server 2008, it was for 2005.
There certainly used to be an issue in sql 2005 where a clustered instance of sql was on a separate node from the clustered DTC and the little MSDTC indicator would show red\stopped.
DTC under Windows 2008 enables you to have multiple dtc objects, typically you would deploy one for each clustered instance that needs it and put it into the sql server cluster group.
DTC is only used for remote calls, linked servers are amongst these.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply