How to setup NIC Teaming to improve SQL server performance and redundancy

I am trying to setup SQL server 2008,  the server in question has two 1GB network cards and I wanted to know if there would be any benefit in teaming these to increase the bandwidth.  When I first mentioned it was suggested that our 3COM switches would not allow this because they would see two network cards with different MAC addresses but the same IP address which would cause an issue.  Is this correct and is there a way to configure this correctly so it does not cause an issue.
WNottsCAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jakethecatukConnect With a Mentor Commented:
To gain the maximum benefit, your switches would need to support LACP (http://en.wikipedia.org/wiki/Link_aggregation) and so would your cards.

Basically, configure the switch for LACP on the two ports that your NIC's are connected to and then configure LACP on your network cards.

Be warned though - you run the risk of reducing performance and breaking your network configuration if you don't know what you are doing.
0
 
jhyieslaConnect With a Mentor Commented:
Part of this depends on the data flow from the server.  So, you team the NICs. What should happen is that one overarching IP is assigned. So, if the primary data flow is outbound, teaming should help as if should allow "double" the data to flow since two ports are in use. However, if the primary flow is into the server, then you are still accessing it via one IP and I believe that only one port will be used... unless as the  other expert mentions, your switch supports this directly.
0
All Courses

From novice to tech pro — start learning today.