• Perry Whittle (4/16/2013)


    SQLSACT (4/16/2013)


    By this do you mean it's not part of the storage allocated to the clustered instance of SQL Server?

    Yep, MSDTC has absolutely nothing to do with SQL Server, SQL Server makes use of it for remote transactions but then so do other Windows services.

    SQLSACT (4/16/2013)


    Currently my DTC is part of the cluster but not part of the SQL group in the cluster, however, the DTC disk has only been presented to Node2 & Node3 - Node1 has it's own DTC disk, which I realize now is moot.

    With all nodes on one site it would make sense to have the DTC available on as many nodes as possible

    SQLSACT (4/16/2013)


    My storage setup is as follows

    I: Drive presented to Node2 & Node3 - For SQL data and log files

    X: Drive Drive presented to Node2 & Node3 for DTC

    I: Drive presented only to Node1 - For SQL data and log files

    X: Drive presented only to Node1 for DTC

    Corrections?

    For the instance, no, makes sense to have the same drive letter and datafile paths.

    DTC i would fail across all nodes, but it's your choice

    Thanks

    DTC i would fail across all nodes, but it's your choice

    Because Node1 has SQL installed as nonclustered, is it safe to say that it's not absolutely necessay to share DTC across all 3 nodes. If I failover my AG to Node1, if DTC is needed when the AG is running on Node1, won't it just use the DTC service on that server?

    Thanks