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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jakethecatukCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jhyieslaCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Networking Hardware-Other

From novice to tech pro — start learning today.