Groups | Blog | Home
all groups > sql server clustering > october 2007 >

sql server clustering : Broadcom NIC Teaming and SQL Server Clusters


salsafreak
10/18/2007 8:30:02 AM
Our failover SQL cluster is a two-node single instance environment - SQL 2000
Enterprise SP4 on Windows Server 2003 Enterprise. We're currently using NIC
teaming to give us some hardware redundancy since the blade has two Broadcom
NICs on it: one for the hearbeat private network and the other that connects
to the public network. Our understanding is that Microsoft discourages this
set up and will ask that you disable teaming when troubleshooting cluster
issues.

My questions:
1. What issues are associated with NIC teaming and, if not this, what other
alternatives are there to minimize a single-point-of-failure (if the one NIC
that connects to the public network goes down, your cluster is down)?
2. Why does Microsoft not want you to use NIC teaming?

Any ideas will be appreciated.
Thanks,
salsafreak
10/18/2007 9:51:01 AM
Thanks for your reply. Actually, given our hardware constraints (a blade
with two physical NICs), we're wondering what are the concerns of teaming up
both physical NICs to create two VLANs - one for the heartbeat and one for
the public network. Given this setup and our goal of achieving redundancy,
what comments would you have on this?

[quoted text, click to view]
Geoff N. Hiten
10/18/2007 11:59:28 AM
NIC teaming is definitely NOT recommended for the heartbeat network. I have
found it useful on the public network(s). Disabling NIC teaming is a first
step in troubleshooting a cluster because it simplifies the setup, not
because it is inherently unstable.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




[quoted text, click to view]
Rodney R. Fournier [MVP]
10/18/2007 12:08:57 PM
I love teaming, but never with Broadcom - the software has issues and has
for years. We team with Intels. Like Geoff said never team the Private.

Both Public and Private can be on VLANs within the same switch.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


[quoted text, click to view]

Geoff N. Hiten
10/18/2007 2:05:57 PM
My comment is simple. Don't.

The extra availability you might get from teaming is countered by teaming
the heartbeat NIC. Quick, lightweight, and fast is what that path needs.
The latency limits are pretty stringent and will end up forcing a node
offline if you miss. Then again, clustering on a blade chassis is not
optimal to begin with.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




[quoted text, click to view]
AddThis Social Bookmark Button