Skip to content

add-dependencies-to-a-sql-server-resource.md

Latest commit

 

History

History
63 lines (41 loc) · 6.53 KB

add-dependencies-to-a-sql-server-resource.md

File metadata and controls

63 lines (41 loc) · 6.53 KB
title Add dependencies to a SQL Server FCI resource
description Add Dependencies to a SQL Server Resource
author MashaMSFT
ms.author mathoma
ms.date 03/14/2017
ms.service sql
ms.subservice failover-cluster-instance
ms.topic how-to
helpviewer_keywords
resource dependencies [SQL Server]
failover clustering [SQL Server], dependencies
clusters [SQL Server], dependencies
dependencies [SQL Server], clustering

Add Dependencies to a SQL Server Resource

[!INCLUDE SQL Server] This topic describes how to add dependencies to an Always On failover cluster instance (FCI) resource by using the Failover Cluster Manager snap-in. The Failover Cluster Manager snap-in is the cluster management application for the Windows Server Failover Clustering (WSFC) service.

Before You Begin

Limitations and Restrictions

It is important to note that if you add any other resources to the [!INCLUDEssNoVersion] group, those resources must always have their own unique SQL network name resources and their own SQL IP address resources.

Do not use the existing SQL network name resources and SQL IP address resources for anything other than [!INCLUDEssNoVersion]. If [!INCLUDEssNoVersion] resources are shared with other resources, the following problems may occur:

  • Outages that are not expected may occur.

  • Service pack installations may not be successful.

  • The [!INCLUDEssNoVersion] Setup program may not be successful. If this problem occurs, you cannot install additional instances of [!INCLUDEssNoVersion] or perform routine maintenance.

Consider these additional issues:

  • FTP with [!INCLUDEssNoVersion] replication: For instances of [!INCLUDEssNoVersion] that use FTP with [!INCLUDEssNoVersion] replication, your FTP service must use one of the same physical disks as the installation of [!INCLUDEssNoVersion] that is set up to use the FTP service.

  • [!INCLUDEssNoVersion] resource dependencies: If you add a resource to a [!INCLUDEssNoVersion] group and you have a dependency on the [!INCLUDEssNoVersion] resource to make sure that [!INCLUDEssNoVersion] is available, [!INCLUDEmsCoName] recommends that you add a dependency on the [!INCLUDEssNoVersion] Agent resource. Do not add a dependency on the [!INCLUDEssNoVersion] resource. To make sure that the computer that is running [!INCLUDEssNoVersion] remains highly available, configure the [!INCLUDEssNoVersion] Agent resource so that it does not affect the [!INCLUDEssNoVersion] group if the [!INCLUDEssNoVersion] Agent resource fails.

  • File shares and printer resources: When you install File Share resources or Printer cluster resources, they should not be put on the same physical disk resources as the computer that is running [!INCLUDEssNoVersion]. If they are put on the same physical disk resources, you may experience performance degradation and loss of service to the computer that is running [!INCLUDEssNoVersion].

  • MS DTC considerations: After you install the operating system and configure your FCI, you must configure [!INCLUDEmsCoName] Distributed Transaction Coordinator (MS DTC) to work in a cluster by using the Failover Cluster Manager snap-in. Failure to cluster MS DTC will not block [!INCLUDEssNoVersion] Setup, but [!INCLUDEssNoVersion] application functionality may be affected if MS DTC is not properly configured.

    If you install MS DTC in your [!INCLUDEssNoVersion] group and you have other resources that are dependent on MS DTC, MS DTC will not be available if this group is offline or during a failover. [!INCLUDEmsCoName] recommends that you put MS DTC in its own group with its own physical disk resource, if it is possible.

Prerequisites

If you install [!INCLUDEssNoVersion] into a WSFC resource group with multiple disk drives and choose to place your data on one of the drives, the [!INCLUDEssNoVersion] resource will be set to be dependent only on that drive. To put data or logs on another disk, you must first add a dependency to the [!INCLUDEssNoVersion] resource for the additional disk.

Using the Failover Cluster Manager Snap-in

To add a dependency to a SQL Server resource

  • Open the Failover Cluster Manager snap-in.

  • Locate the group that contains the applicable [!INCLUDEssNoVersion] resource that you would like to make dependent.

  • If the resource for the disk is already in this group, go to step 4. Otherwise, locate the group that contains the disk. If that group and the group that contains [!INCLUDEssNoVersion] are not owned by the same node, move the group containing the resource for the disk to the node that owns the [!INCLUDEssNoVersion] group.

  • Select the [!INCLUDEssNoVersion] resource, open the Properties dialog box, and use the Dependencies tab to add the disk to the set of [!INCLUDEssNoVersion] dependencies.