PRB: Cluster Group Containing SQL Server and MS DTC Moves Slowly

• Microsoft SQL Server, Enterprise Edition, versions 6.5, 7.0

SYMPTOMS

When moving a cluster group containing both Microsoft Distributed Transaction Coordinator (MS DTC) and SQL Server resources between nodes, it takes several minutes to take the resources offline and move the group to the other node. However, if the MS DTC resource is taken offline before moving the group, the group moves to the other node quickly.

WORKAROUND

Add the Virtual Generic Service that the SQL Server Cluster Wizard creates to the list of dependencies for the MS DTC resource. To do so, use Cluster Administrator and perform the following steps:

1. Right-click the MS DTC resource, then click Properties on the shortcut menu.



2. On the Dependency tab, click Modify.



3. Under Available Resources, double-click the Generic Service resource, which the SQL Cluster Wizard created, to add it to the Dependencies list.



4. Click OK to close the Modify Dependencies window.



5. Click OK to close the MS DTC Properties window.

• Virtual Network Name



• Physical Disk



• Virtual Generic Service

MORE INFORMATION

IMPORTANT: Before unclustering SQL Server, you must remove this dependency as follows:

1. Right-click the MS DTC resource, then click Properties on the shortcut menu.



2. On the Dependency tab, click Modify.



3. In the Dependencies list, double-click the Generic Service resource, which the SQL Cluster Wizard created, to move it back to the Available Resources list.



4. Click OK to close the Modify Dependencies window.



5. Click OK to close the MS DTC Properties window.

• Virtual Network Name



• Physical Disk

Additional query words:

Keywords          : kbSQLServ650 kbSQLServ700 
Version           : winnt:6.5,7.0
Platform          : winnt 
Issue type        : kbprb 

Last Reviewed: April 29, 1999