SQL Server Performance

Direct connect gigabit cards

Discussion in 'Performance Tuning for Hardware Configurations' started by clending@brockport.edu, Apr 12, 2004.

  1. clending@brockport.edu New Member

    Hi All,

    I have two Dell2650's, both with dual gigabit cards, that I am trying to directly connect. One card in each is connected to the local LAN via TCPIP. I want to use the remaining cards to use a reverse cable to isolate the SQL servers. I have set up these two cards with TCP/IP and non-routable (sp?) addresess of 192.168.1.1 and 192.168.1.2. I can register the SQL servers, but when I go to transfer a database, it seems that the gigabit connection is not used and instead the traffic goes over the LAN. Is there any way to force the gigabit connection between the computers?

    Tks
    clending@brockport.edu, Apr 12, 2004
    #2

  2. Twan New Member

    Hi ya,

    You'd need to use a host file to make sure that the database server's name translates to 192.168.1.1 or .2 When you type ping <server> on a command prompt at the server, what IP address do you get? replacing <server> with the name of the server you're connecting to. Make sure that it gives you the 192.168.1.1 or .2 address

    Cheers
    Twan
    Twan, Apr 12, 2004
    #2

Share This Page