SQL 2012 Multi Instance Cluster - DTC

  • Hi all

    I am required to set up a multi-instance SQL/Windows Cluster.

    Windows 2012 Ent/SQL 2012 Ent

    There will be 12 instances across 4 nodes.

    Which considerations do I need to take for DTC?

    Do I need DTC in this scenario?

    Is it best to create a clustered DTC service for each SQL instance?

    Any suggestions will be appreciated

    Thanks

  • Hi,

    You should start out by mapping what instances require DTC as it's not something you automatically need (after SQL Server 2005, which did require it for cluster installation). SQL Server uses DTC for things like Linked Server, Distributed Queries and Remote Procedure Calls to name a few. Once you've figured that out, you need an estimate on how much their going to be used and based on that decide number of DTCs.

    When you know the number of DTCs you want to run on your cluster there's few things to consider. If all your instances use DTC directly, or features that require it, it might make sense to add DTC to every FCI and have it in a same resource group than the SQL Server. This way your DTC is also always in the same node than the SQL Server, but it adds one more thing to your SQL Server that can cause a failover. If only few instances use DTC and they don't use it a lot, you might go with one or two clustered DTCs in their own groups. This way they might end up to different node than the SQL Server using them and they require their own disk, name and IP each.

    If you don't know wether you need DTC or not and how much their used, start with simple setup and have one, then monitor the performance and if you need more then add some.

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • SQLSACT (7/22/2014)


    Hi all

    I am required to set up a multi-instance SQL/Windows Cluster.

    Windows 2012 Ent/SQL 2012 Ent

    There will be 12 instances across 4 nodes.

    Which considerations do I need to take for DTC?

    Do I need DTC in this scenario?

    Is it best to create a clustered DTC service for each SQL instance?

    Any suggestions will be appreciated

    Thanks

    You can either use a single clustered DTC resource for all instances if the remote activity is minimal. If you have instances that are heavy on remote activity i would deploy a dedicated DTC for that instance.

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

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

  • MikaS (7/22/2014)


    it's not something you automatically need (after SQL Server 2005, which did require it for cluster installation).

    Whilst it's not actually required for 2008 onwards, the installer still bitches and moans if you don't have one configured 😉

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

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

Viewing 4 posts - 1 through 3 (of 3 total)

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