Post reply

Multiple NIcs and SQL Server

  • December 4, 2007 at 5:38 am

    #153995

    Hi,

    If a server uses 2 nics, does sql know to use both or is it at the OS level?

    if multiple NICs are there, how can i use if for SQL Server

    Regards

    Nimesh

  • December 4, 2007 at 10:24 am

    #757054

    what u mean by NIC

  • December 4, 2007 at 10:45 am

    #757068

    It's something SQL server doesn't care about - multi-homing is done at the OS level.

    You want to figure out what traffic you can steer to "what" Network interface card.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • July 11, 2011 at 12:42 am

    #1350893

    I've got Servers with multiple NIC's on multilple vlan's configured for backups.

    NIC 1 - 10.10.0.x Vlan 1

    NIC 2 -- 10.10.9.x Vlan 9

    In DNS I've also added new entries for both servers.

    eg, sql1.domain.com(10.10.0.x) and I've added a second entry sql1backup.domain.com(10.10.9.x)

    Make sure your routing is confiured correctly on both servers....test your routing with pathping.

    Eg. pathping 10.10.9.x , should go over NIC 2

    You can also add persistent routes on each server

    route -p add 10.10.9.0 mask 255.255.255.0 10.10.9.x(IP of second NIC)

    Hope this helps

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply