SQL Server Performance

MSDTC on cluster

Discussion in 'SQL Server Clustering' started by suniljk, Jun 27, 2007.

  1. suniljk New Member

    Dear all,

    We have to configure two node active/passive cluster on windows 2003 R2 with sql server 2000. now we some limitation with the shared disk. we have one Quram drive which is raid1 and another drive with raid5 and one more disk which is kept for backup. Now we need to configure MSDTC on the cluster which need to a disk, but we don't have that. so we are thinking to configure this MSDTC on the backup disk can we do this?? will this create any issue or what else we can do??

    Please guide me on this.

    Thanks
    Sunil
  2. Argyle New Member

    If you dont have heavy MSDTC usage let it use the quorum disk instead. The MSDTC service will den be located in the default cluster group where you have the cluster ip and name.
  3. suniljk New Member

    quote:Originally posted by Argyle

    If you dont have heavy MSDTC usage let it use the quorum disk instead. The MSDTC service will den be located in the default cluster group where you have the cluster ip and name.


    Thanks for the reply:
    so i can use quram drive for MSDTC right.. its better than using backup drive.. right?? actually we don't have much use of MSDTC.

    Sunil
  4. Argyle New Member

    It has to be in a cluster group that has an IP and a name resource as well. I don't think your backup drive has that unless it is located in your SQL Server group. And I wouldn't put MSDTC in the same group as SQL Server. Put it on the group that has the quorum disk.
  5. suniljk New Member

    quote:Originally posted by Argyle

    It has to be in a cluster group that has an IP and a name resource as well. I don't think your backup drive has that unless it is located in your SQL Server group. And I wouldn't put MSDTC in the same group as SQL Server. Put it on the group that has the quorum disk.


    Thanks so i will use Cluster Group, which will also use Quram disk for MSDTC. one more question how should i install?? i will install SQL first and then MSDTC or MSDTC first and the sql server?? which is preferable please guide me on this as well.

    Thanks
    sunil
  6. MohammedU New Member

Share This Page