SQL Server Performance

Moving SQLCluster DTC and SQLQueue Services`

Discussion in 'SQL Server 2005 Clustering' started by danny123, Aug 16, 2010.

  1. danny123 New Member

    Hi there,
    In our sql cluster set up we have all the services on one node other than SQLCluster DTC and SqlQueue services. Now we need to restart the second node for maintenance. Will users be affecting anything issues if we move the 2 services from one node to another?
    Thanks!!!
    danny123, Aug 16, 2010
    #2

  2. ashish287 New Member

    as long your failover is successfull, the user might face problem for fraction of seconds but they can logout and login back if they having issue still.
    But make sure your dtc is running and the services you moved on other node are also running.
    ashish287, Aug 16, 2010
    #3

  3. satya Moderator

    True and do the failover/move of services during less traffic hours to ensure the transactions are not missed. It is a best practice.
    satya, Aug 18, 2010
    #4

  4. danny123 New Member

    Thanks guys, that was really helpful.
    danny123, Aug 18, 2010
    #5

  5. satya Moderator

    Not only that...make sure you post the final result here to know whether it worked or not
    satya, Aug 18, 2010
    #6

Share This Page