2

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?

Mat
  • 10,289
  • 4
  • 43
  • 40
user2119955
  • 21
  • 2

1 Answers1

6

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

mrdenny
  • 27,106
  • 2
  • 44
  • 81