Post reply

active\active sql server 2008 r2 cluster how many msdtc services we need?

  • May 30, 2012 at 2:54 pm

    #256794

    Hi,

    I'm configuring an active\active sql server 2008 r2 cluster how many msdtc services do we need to configure?

    Thanks I appreciate your help

    APA

  • May 30, 2012 at 4:58 pm

    #1494963

    starter for 10

    http://blogs.msdn.com/b/cindygross/archive/2009/02/22/how-to-configure-dtc-for-sql-server-in-a-windows-2008-cluster.aspx

    ---------------------------------------------------------------------

  • May 30, 2012 at 6:09 pm

    #1494971

    george sibbald (5/30/2012)

    starter for 10

    http://blogs.msdn.com/b/cindygross/archive/2009/02/22/how-to-configure-dtc-for-sql-server-in-a-windows-2008-cluster.aspx

    Thanks for the article very helpful , based on your experience what do you recommend for 2 nodes active\active , 2 sql server instances

    Thanks

    APA

  • May 31, 2012 at 3:51 am

    #1495079

    so far all my clusters have been active\passive so I would not like to venture an opinion, see if any one else jumps in.

    ---------------------------------------------------------------------

  • May 31, 2012 at 4:06 am

    #1495086

    I've just checked our cluster (Server 2008, SQL 2008, 4 node, 3 instance) and each instance has its own MSDTC, but I have worked in a multi instance environment before where there was only 1 MSDTC for the cluster (Servere 2003, SQL 2005, 3 node, 2 instance).

    It really depends what you want and the impact on fail over, the link which George provided goes into the different configurations and the impacts they have on fail over etc, so pick the one which suits your application requirements.

  • May 31, 2012 at 4:21 pm

    #1495595

    APA0876 (5/30/2012)

    what do you recommend for 2 nodes active\active , 2 sql server instances

    Thanks

    APA

    Are you expecting a large amount of remote transactions on each instance? One DTC for each instance would be fine if you are. Put each DTC into the SQL group so that it fails with the instance.

    anthony.green (5/31/2012)

    a multi instance environment before where there was only 1 MSDTC for the cluster (Servere 2003, SQL 2005, 3 node, 2 instance).

    with Windows server 2003 you could not utilise multiple DTCs in the same you can with Windows server 2008.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • June 1, 2012 at 1:55 am

    #1495700

    Thanks Perry, learnt something new on that one.

  • June 1, 2012 at 4:35 am

    #1495772

    If you have a MSDTC instance local to your SQL Server instance, they can use memory to communicate. If MSDTC and SQL Server are on separate nodes they have to use the network to communicate.

    Setting up multiple MSDTC instances and binding SQL Server to the MSDTC instance is a many-step process. The link from George covers the steps needed. If you want to automate all of this, then FineBuild gives you a command-line install that builds the MSDTC and SQL clusters and links everything together.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply