Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kdubb777
Starting Member
24 Posts |
 Posted - 2007-11-19 : 18:54:39
|
| Does anyone know of any issues with using a cross over cable between two dedicated NIC's on DB servers in a mirroring setup.This would be instead of using one NIC in each DB server wired to the switch. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 16:55:14
|
| How do you force sql use that link for db mirroring trafic? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-23 : 21:56:44
|
| With database mirroring, you specify an endpoint which points to a port. Is it even possible to get a specific port to work only on a certain NIC?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
kdubb777
Starting Member
24 Posts |
Posted - 2007-12-05 : 15:39:15
|
| Tara thanks for the reply. I don't see anything in the MS mirroring deployment docs about using a dedicated cross over cable for the two phase commit mirroring. But they specifically mention it for a two node failover cluster heartbeat. I can't see anyway that using the crossover for mirroring would affect the ability to failover do you?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-05 : 22:55:51
|
| You miss the point. How do you let sql use cross over cable for db mirroring traffic? |
|
|
|
kdubb777
Starting Member
24 Posts |
Posted - 2007-12-06 : 18:10:54
|
| rmiao, That's the easy part. In mirroring you setup endpoints. Each SQL server can have only one MIRRORING endpoint which is setup like N'TCP://MyIP:5022' and therefore tells the mirroring functionality to use this specific IP address. The IP address you assign to the mirroring endpoint is the one that is assigned to the private NIC and connected to the other server via the crossover cable. Another way to see that in fact SQL server is sending the two phase commits over this dedicated crossover cable is to use perfmon select the Network Interface performance object and then the private NIC instance and select the bytes Total/sec or Bytes Sent/sec. Now run a big insert script or something on the Principal and you will see that all that two phase commit trafic is going over your dedicated NIC with crossover cable.Kevin- |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-06 : 22:38:20
|
| Ok, then did you test it? Does it failover to mirrored db by pulling out public network cable on source server? |
|
|
|
|
|
|
DB mirroring with dedicated NIC's and crossover