SQL Server Performance

MS DTC in clustering setup

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by WingSzeto, Nov 7, 2008.

  1. WingSzeto Member

    Our shop doesn't use distributed transactions so I assume MS DTC is not being used heavily. And if DTC is being used, it would have to be part of the SQL processes. We do use Integration Service and I usually develop it in my laptoop and create a package. Then put the package in the production SQL server for a schedule job. With that in mind, since SQL clustering requires DTC to be allocated in a resource and tie to a disk. If I were to set up a disk with its own LUN for MS DTC, how much space do I need to allocate for it?
    Wingman
  2. Elisabeth Redei New Member

    Hi,
    Is your only question how much space MSDTC needs for it's log? It's default size is a mere 4192 KB but yo probably want your disk resource a little bit bigger than that :)
    Before you go ahead and install MSDTC, please read http://support.microsoft.com/?id=301600, "How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster". Even if you are not going to use it now, there might come a day when someone wants to use it so you might as well do it right.
    After you have set it up and verified that it is failing over properly, take the entire Resource Group offline and keep it like that until someone wants to use it(in that way it is not going to bother you if it is having problems).
    HTH!
    /Elisabeth
  3. WingSzeto Member

    I should have clarified what I have. We are using SQL 2008 std 64 bit on Windows 2008 64 bit. The DTC setup is a litttle different now in this Windows 2008 version. Do you have any experience in this version?
    Wingman
  4. Elisabeth Redei New Member

    Hi,
    Actually I don't, but luckily other people do :) Read MVP Geoff Hiten's blog: http://weblogs.sqlteam.com/geoffh/a...ation-for-Windows-2008-SQL-2005-Clusters.aspx.
    It contains a link to a to the Windows 2008 documentation "Understanding MS DTC Resources in Windows Server 2008 Failover Clusters", (http://technet2.microsoft.com/windo...993bfdca-eea4-44cc-9432-b14449c830781033.mspx) which presents the various options you have for MSDTC in a cluster on Windows 2008.
    Once you have decided how you want to set it up on your cluster, you can move on to "Requirements for Creating an MS DTC Resource in a Failover Cluster", http://technet.microsoft.com/en-us/library/cc770748.aspx.
    I apologize for the numerours links but since I have no experience in 2008 clusters, it is better if you get the information from the horse's mouth!
    HTH!
    /Elisabeth

Share This Page