March 22, 2002 at 9:31 am
HI,
I'm looking at implementing two SQL servers at two sites that will replicate over night via a fix connection. What I'm looking for an answer to is does anyone know what sort of speed the connection should be. I'm mean are we talking 2 Mbps or 10 Mbps?? It makes a big price difference when working on costings.
Thanks
Darryl
March 22, 2002 at 11:31 am
Depends on the volume of course, but I'd bet you can get by with the 2m connection. Put a 10m NIC in a box and try it locally.
Andy
March 22, 2002 at 11:56 am
Locally may not show network bottlenecking issues that will appear when done. It depends first on the amount of data to deliver first then how much will be moved each time? But no matter you will want to test it beforhand to see if feasible. I have several transactional replications that were 2gb databases on a 10mb network there are fine. You will also want to consider how often, urgency and such when decided on a model of replication. Can you give us an idea?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 22, 2002 at 12:48 pm
I agree the 10m NIC isn't a perfect simulation, but for something like a snapshot is better than nothing to gauge the time!
Andy
March 23, 2002 at 2:47 am
Andy,
Is there not a way of simulating connections below 10 MBit/s ?
Other than setting up two 56 kBit/s modems?
Some years ago it was possible to move data over a printer cable.
Could the same thing not happen on a USB cable?
Henrik
March 23, 2002 at 5:11 am
Thats a good question! I guess the ideal would be a way to specify the bandwidth - maybe can be done at a router or switch. Lets see if Steve has ideas?
Andy
March 23, 2002 at 6:42 am
Intel's anypoint home network is 1.6mb transmitted. But this was the first version and is hard to find anywhere other than compusa and ebay, the new version may be a higher bandwidth but I don't remember.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply