Adding new NICs to SQL Server Cluster

Bojan Zivkovic 466 Reputation points
2024-11-16T08:36:29.4633333+00:00

Hi, we have 2-node SQL Server 2019 cluster in production. Former colleague did not use dedicated NICs just for inter-node heartbeat communication potentially causing issues on daily basis. I would like to add NIC/per cluster node in separate VLAN that would be used just for inter-node heartbeat communication. Is that doable on live cluster?

Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
1,016 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Marcin Policht 27,825 Reputation points MVP
    2024-11-16T08:42:02.7433333+00:00

    That depends on the hardware support (hot-add NIC).

    In any case, you might want to consider performing the change on the passive node first, failing over, and repeating the change on the other node (once it becomes passive)


    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin


  2. Ian Xue 38,551 Reputation points Microsoft Vendor
    2024-11-19T03:24:15.2466667+00:00

    Hi Bojan,

    Thanks for your post. To add the additional the NIC, it is highly recommended to take action in the maintenance window as we need to affinity between pNICs and vNICs brings in flexibility to route network traffic across teamed pNICs. With this feature, you can increase throughput by mapping RDMA capable physical adapter with RDMA settings enabled vNIC. Also, you can route specific type of traffic (for example, live migration) to a higher bandwidth physical adapter. In HCI deployment scenarios, by specifying affinity, you can use SMB multichannel to meet high throughput for SMB traffic.

    Reference: Set up networking for Hyper-V hosts and clusters in the VMM fabric | Microsoft Learn

    Best Regards,

    Ian Xue


    If the Answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.