SQL Server Performance

Direct connect gigabit cards

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

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

Share This Page