InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 03:40:01 GMT20http://www.sqlservercentral.com/Forums/Topic1423504-1549-1.aspxThanks Guys - This clears up a lotPerry, would you say that it's safe to not cluster DTC when you have a single node cluster?ThanksThu, 28 Feb 2013 06:11:19 GMTSQLSACThttp://www.sqlservercentral.com/Forums/Topic1423504-1549-1.aspx[quote][b]SQLSACT (2/26/2013)[/b][hr]So even if SQL is installed as non clustered, DTC can still become involved somehow[/quote]DTC is not just used for SQL Server, the OS uses it for remote calls too.[quote][b]SQLSACT (2/26/2013)[/b][hr]If that's the case, why when dealing with Clustered instances of SQL Server do we have to explicitly create a DTC component in the Cluster?Thanks[/quote]In a clustered environment, a clustered DTC is used to recover inflight transactions. Take the following scenario:Node1 and Node2 have a clustered instance INST1 which is currently active on Node1. DTC is local and not clustered.A remote transaction is started and during the transaction the instance goes offline and fails over to Node2. The SQL instance is no longer local to the stand alone DTC and cannot connect to recover the inflight transaction.Thu, 28 Feb 2013 03:44:58 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1423504-1549-1.aspx[quote]So even if SQL is installed as non clustered, DTC can still become involved somehow[/quote]Yep.[quote]If that's the case, why when dealing with Clustered instances of SQL Server do we have to explicitly create a DTC component in the Cluster?[/quote]My understanding is that the Windows cluster relies on it. DTC is not a SQL Server-specific piece of software. It is a stand-alone Windows service that SQL Server sometimes leverages. SQL Server clusters sit on top of Windows clusters, and its the Windows cluster that requires the DTC to be configured.Wed, 27 Feb 2013 09:05:57 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1423504-1549-1.aspx[quote][b]opc.three (2/26/2013)[/b][hr]SQL also will the DTC if you try using explicit transactions with Linked Servers. I also use it with SSIS transactions, not technically the database engine but another use of DTC nonetheless.[/quote]ThanksSo even if SQL is installed as non clustered, DTC can still become involved somehowIf that's the case, why when dealing with Clustered instances of SQL Server do we have to explicitly create a DTC component in the Cluster?ThanksTue, 26 Feb 2013 23:14:11 GMTSQLSACThttp://www.sqlservercentral.com/Forums/Topic1423504-1549-1.aspxSQL also will the DTC if you try using explicit transactions with Linked Servers. I also use it with SSIS transactions, not technically the database engine but another use of DTC nonetheless.Tue, 26 Feb 2013 21:03:28 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1423504-1549-1.aspxHi AllI am trying to figure out the ins and outs of DTC and how SQL uses it.Does SQL only ever use DTC when SQL is installed as clustered?ThanksMon, 25 Feb 2013 02:33:53 GMTSQLSACT