Re: Cluster groups and failover

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mike Rosado [MSFT] (mikeros_at_online.microsoft.com)
Date: 03/24/05 

Date: Thu, 24 Mar 2005 08:22:32 -0600

Hello Everyone,

There are many different theories of where MSDTC should reside. As the
following article states, "If SQL Server is clustered, only one instance of
MSDTC is required." Same would go for Exchange, but the only difference is
that Exchange uses MSDTC when Service Packs and/or Hotfixes are being
applied which is why it doesn't matter if it's in the Cluster Group.
Otherwise, Exchange doesn't use MSDTC as oppose to SQL depending what it's
role will be may use MSDTC very frequently.

For more information, reference the statement below for the following
article:

243204 Microsoft Distributed Transaction Coordinator (MSDTC) Recovery
http://support.microsoft.com/?id=243204

The recommended procedure for installing an MSDTC Resource is to install it
in a group other than the Cluster Group. If the MSDTC resource has already
been installed and it is in the Cluster Group and SQL is functioning
correctly, it is recommended that you leave it in that location. If the
cluster is not yet in production, it is recommended that SQL be unclustered
and the following procedures be used to move the MSDTC resource to a group
other than the Cluster Group.

Reference the following articles depending on the OS for more information on
installation of MSDTC:

290624 How to configure MSDTC in a Windows 2000 cluster environment
http://support.microsoft.com/?id=290624

301600 How to configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600 

-- 
Hope this helps,
Mike Rosado
Windows 2000 MCSE + MCDBA
Microsoft Enterprise Platform Support
Windows NT/2000/2003 Cluster Technologies
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
<http://www.microsoft.com/info/cpyright.htm>
-----Original Message-----
"Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in
message news:uFODzlHMFHA.508@TK2MSFTNGP12.phx.gbl...
> I disagree, we have a SQL cluster that uses the heck out of MSDTC. It
> belongs in its own group.
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
>
> "Greg Page" <gpage@nospam.microsoft.com> wrote in message
> news:iGpSRTHMFHA.3668@TK2MSFTNGXA03.phx.gbl...
> >
> > It doesn't depend on the application at all. That's the current wisdom
on
> > DTC.
> >
> > --------------------
> > | From: "Russ Kaufmann" <russ@exchangemct.com>
> > | References: <4724C2D6-D1AB-4414-87DA-B78F0F1853D4@microsoft.com>
> > <B6AD8835-0852-4DAC-8BF4-8A449753EB3A@microsoft.com>
> > <22zy71JLFHA.2644@TK2MSFTNGXA02.phx.gbl>
> > | Subject: Re: Cluster groups and failover
> > | Date: Mon, 21 Mar 2005 12:24:59 -0700
> > | Lines: 9
> > | X-Priority: 3
> > | X-MSMail-Priority: Normal
> > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> > | X-RFC2646: Format=Flowed; Original
> > | Message-ID: <uNDntukLFHA.2492@TK2MSFTNGP14.phx.gbl>
> > | Newsgroups: microsoft.public.windows.server.clustering
> > | NNTP-Posting-Host: machine77.level3.com 209.244.4.106
> > | Path:
> >
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP1
> > 4.phx.gbl
> > | Xref: TK2MSFTNGXA02.phx.gbl
> > microsoft.public.windows.server.clustering:8482
> > | X-Tomcat-NG: microsoft.public.windows.server.clustering
> > |
> > | "Greg Page" <gpage@nospam.microsoft.com> wrote in message
> > | news:22zy71JLFHA.2644@TK2MSFTNGXA02.phx.gbl...
> > | > Actually, that recommendation has been updated to say "sure, go for
it
> > and
> > | > toss the DTC resource in there as well, chief".
> > |
> > | It depends on the applications being run on the cluster. If the
> > application
> > | regularly utilizes DTC, it should have its own resources.
> > |
> > |
> > |
> >
>
>

Relevant Pages

  • Re: SQL 2008 Installation
    ... As long as the instance count is less than 2x the node count, ine MSDTC per ... you will get better resource ... But in a cluster with more than one SQL instance makes sence to have one ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server Cluster and MSDTC
    ... Principal SQL Infrastructure Consultant ... MSDTC and that appears to be a fairly complicated process for a humble DBA. ... When clustering SQL on Windows 2003 you have to first cluster MSDTC ... profiler and I can't find any applications that use distributed transactions, ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server Cluster and MSDTC
    ... If you have more than twice the instances as you have nodes, then local MSDTC is good. ... Principal SQL Infrastructure Consultant ... article talks about using a local DTC in a failover cluster. ... >>> coordinate distributed transactions to ensure consistent updates ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2008 Installation
    ... But in a cluster with more than one SQL instance makes sence to have one ... MSDTC per SQL Cluster Instance, or have only one MSDTC in a dedicated ... resource local to the instance. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2008 Installation
    ... As long as the instance count is less than 2x the node count, ine MSDTC per Instance is a good setting. ... you will get better resource management with one MSDTC instance per node. ... But in a cluster with more than one SQL instance makes sence to have one ...
    (microsoft.public.sqlserver.clustering)