Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How can I configure SQL Server 2012 to use multiple NICs?

I've a server with 4 NICs. I want to use 2 NICs to query my databases, and 2 NICs to retrieve results from them.

I want them to work in load balancing mode and still continue to work if one nick is down.

It is possible?

share|improve this question

migrated from stackoverflow.com Mar 5 '13 at 18:36

This question came from our site for professional and enthusiast programmers.

    
What exactly you are trying to achieve by separating the NICs for different purposes? –  vonPryz Mar 6 '13 at 9:03

1 Answer 1

As long as the OS is configured for NIC teaming SQL server will use the team. SQL Server doesn't talk directly to the network cards, all the communications goes through the TCP/IP stack which is a part of the OS. However the OS is configured to use the NICs will be how SQL Server uses the NICs.

To do what you describe will require doing NIC bonding (aka. NIC teaming).

share|improve this answer
    
ok, i've found out nic teaming in windows server 2012, but what about separing query from result? –  user2119955 Mar 6 '13 at 8:39
    
You aren't going to be able to force the request down one NIC and the results down a different NIC. All you can do is let Windows load balance the traffic across the all the NICs which are teamed (or bonded) together. Windows will pipe a single large result across multiple NICs at the same time as it sees fit. –  mrdenny Mar 6 '13 at 12:29

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.