Share via

Teaming probably causing SAN access issues on sql cluster

create share 666 Reputation points
2024-02-15T10:11:52.8933333+00:00

Hi, We have a two-node SQL cluster on physical servers. Teaming is enabled on the servers, probably causing issues with the cluster disks mapped from a SAN device. We are not able to access the disk management due to this problem. Should we disable Teaming on the servers or is there a specific setting we can do to fix this problem? Thanks.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,997 questions
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,008 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Net Runner 615 Reputation points
    2024-02-16T18:03:33.14+00:00

    If your SAN is connected to your cluster nodes over iSCSI, using network teaming is not recommended since it may cause significant performance degradation and various connectivity issues depending on the network adapter vendor. Break network teams into separate networks and use dedicated network subnets for iSCSI SAN traffic so it does not interfere with other networks. Make sure to use MPIO instead of Teaming.

    More information on that matter can be found here: https://www.starwindsoftware.com/blog/lacp-vs-mpio-on-windows-platform.

    0 comments
  2. create share 666 Reputation points
    2024-02-19T20:59:34.9033333+00:00

    No, it is a fabric connection, and it seems, it is not because of the Teaming. I broke the teaming but it was still the same. If I disable the HBA Card in the Device Manager, the servers work normally but after re-enabling it, Device Manager does not work and windows explorer shows a blank screen after logging into the servers. I have to press Ctrl+Shift+Esc to bring up the Task Manager, open the control panel, and then My Computer Window. Thanks.

    0 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.