Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 2


By:   |   Updated: 2020-10-07   |   Comments   |   Related: More > Clustering


Problem

In a previous tip on Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 1, I have seen how to install a SQL Server 2016 on a Windows Server 2016 failover cluster (WSFC). We are migrating to a SQL Server 2019 failover cluster running on Windows Server 2019. How do I go about installing and configuring a SQL Server 2019 failover cluster on Windows Server 2019?

Solution

To continue this series on Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster, we will look at configuring the Windows Server 2019 failover cluster according to Microsoft best practices in preparation for installing SQL Server 2019. In Part 1, you have learned of the new Windows Server 2019 failover clustering features that apply to SQL Server. You've also installed the Failover Clustering feature on all the servers that you want to include in the WSFC, ran the Failover Cluster Validation Wizard, created the WSFC, and configured a witness. This tip will walk you through configuration of the WSFC according to Microsoft best practices.

Renaming Shared Storage Resources

As a best practice, you should rename your shared storage resources prior to installing SQL Server 2019. This makes it easy to identify what the disks are used for - data, log, backups, etc. - during the installation and later when troubleshooting availability issues. And while you may have renamed the disks using the Disk Management console, you still have to rename them from the point-of-view of the WSFC. The default names of the shared storage will be Cluster Disk n where n is the number assigned to the disks.

failover cluster manager

To rename the shared storage resources:

  1. Within the Failover Cluster Manager console, under the Storage navigation option, select Disks. This will display all the shared storage resources added to the WSFC.
failover cluster manager
  1. Right-click one of the shared disks and select Properties. This will open the Properties page for that specific disk.
failover cluster manager
  1. In the Properties page, on the General tab, type the appropriate name for the shared disk in the Name textbox. Click OK.
cluster disk properties

Do this on all the shared storage resources available on your WSFC.

failover cluster manager

Alternatively, you can use the PowerShell script below to identify the clustered disks and their corresponding disk properties. The DiskGuid property of the cluster disk is used to identify the Path property of the physical disk. The Path property of the physical disk is used to identify the DiskPath and DriveLetter properties of the logical partition. The DriveLetter property of the logical partition is used to identify the FileSystemLabel property of the disk volume.

Foreach ($a in (Get-ClusterResource | Where {$_.ResourceType -eq "Physical Disk"} | Get-ClusterParameter -Name DiskGuid))
{
$ClusterDiskGuid=$a.Value.ToString()
$Disk=Get-Disk | where {$_.Path -like "*$ClusterDiskGuid"} | Select DiskNumber, Path
$Partition=Get-Partition | where {$_.DiskPath -like $Disk.Path} | Select DriveLetter, DiskPath
$Volume=Get-Volume | where {$_.DriveLetter -eq $Partition.DriveLetter} | Select FileSystemLabel
 
"Cluster Disk Name: " + $a.ClusterObject + " , Disk Number: " + $Disk.DiskNumber + " , Drive Letter: " + $Partition.DriveLetter  + " , Volume Label: " + $Volume.FileSystemLabel
}
powershell script

Once you’ve mapped the cluster disks with the corresponding physical disks, you can rename them accordingly using the PowerShell command below, replacing the appropriate values.

(Get-ClusterResource -Name "Cluster Disk 1").Name = "SQL_DISK_R"

Renaming Cluster Network Resources

Similarly, you should rename your cluster network resources prior to installing SQL Server 2019. And while you may have renamed the network adapters using the Network Connections management console, you still have to rename them from the point-of-view of the WSFC. The default names of the cluster network resources will be Cluster Network n where n is the number assigned to the cluster network adapter. In the setup shown, three network adapters are configured – one for production network, one for private/heartbeat communication, and one for iSCSI network. By default, all available network adapters will be used for inter-node communication, or what is commonly known as private communication/heartbeat. Configuring another network adapter provides resiliency and redundancy for inter-node communication.

failover cluster manager

To rename the cluster network resources:

  1. Within the Failover Cluster Manager console, select the Networks navigation option. This will display all the cluster network resources added to the WSFC.
failover cluster manager
  1. Right-click one of the cluster network adapters and select Properties. This will open the Properties page for that specific cluster network resource.
failover cluster manager
  1. In the Properties page, type the appropriate name for the cluster network resource in the Name textbox. Click OK.
cluster network properties

NOTE: The WSFC will automatically detect whether client applications can connect thru the specific cluster network resource. This is determined based on whether a network adapter has a default gateway and can be identified via network discovery. Thus, it is important to get your network administrators involved in properly assigning the IP address, the subnet mask and the default gateway values of all the network adapters used on the WSFC nodes prior to creating the WSFC. An example of this is the network adapter configured for inter-node communication.

cluster network properties

Other network adapters also need to be configured properly. The network adapter used for iSCSI in the example cluster has the Do not allow cluster network communication on this network optionselected.

iscsi properties

Do this on all the cluster network resources available on your WSFC.

failover cluster manager

Again, all available network adapters will be used for inter-node communication, including the network adapter you configure for production network traffic. How the WSFC prioritizes which network adapter is used for private/heartbeat communication traffic is determined by using the cluster network adapter’s Metric property value. You can identify the cluster network adapter’s Metric property value by running the PowerShell command below.

Get-ClusterNetwork | Sort Metric

The cluster network adapter with the lowest Metric property value will be used for private/heartbeat communication (and cluster shared volume, if it is configured). In the example provided, the Private cluster network adapter will be used for private/heartbeat communication. And since LAN cluster network adapter has value of ClusterAndClient for the Role property, the WSFC will use it in case the Private cluster network adapter becomes unavailable. This is described in more detail in the Configuring Network Prioritization on a Failover Cluster blog post from Microsoft.

Alternatively, you can use the PowerShell script below to identify the clustered network resources and rename them accordingly.

#Display all cluster network resources
Get-ClusterNetworkInterface
 
#Rename cluster network resources accordingly based in the result of Get-ClusterNetworkInterface
(Get-ClusterNetwork –Name "Cluster Network 1").Name = "LAN"
(Get-ClusterNetwork –Name "Cluster Network 2").Name = "Private"
(Get-ClusterNetwork –Name "Cluster Network 3").Name = "iSCSI"
powershell script

In this tip, you have learned the following items:

  • Renamed the shared storage resources
  • Renamed the cluster network resources and
  • Viewed network prioritization for cluster network adapters.

In the next tip in this series, you will go thru the process of installing SQL Server 2019 on top of the WSFC.

Next Steps


Last Updated: 2020-10-07


get scripts

next tip button



About the author
MSSQLTips author Edwin Sarmiento Edwin M Sarmiento is a Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures.

View all my tips
Related Resources





Comments For This Article





download





Recommended Reading

Getting started with SQL Server clustering

Force Start a Windows Server Failover Cluster without a Quorum to bring a SQL Server Failover Clustered Instance Online

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 1

Configure Network Binding Order for a Windows Server 2016 Failover Cluster

Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 1








get free sql tips
agree to terms