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 |
|
aasimkhalid
Starting Member
2 Posts |
 Posted - 2008-03-11 : 10:20:13
|
| Hi All,I am setting up P2P replication for a high latency environment (although at 100MBit per sec, the bandwidth is not a serious issue ). I have noticed that at high load, the bandwidth between Distribution and Subscriber servers maxes out at 1MBit per second (our network bandwidth is 100MBit per second). This causes transactions to 'back up' and when the load reduces they 'catch up' and synchronise.Does anyone know where this limitation of 1Mbs is being enforced and what is the way round it?I have seen the -SubscriptionStreams NN parameter, but this is not applicable in P2P replication.Any advice would be appreciated.Thanks Aasim |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-11 : 23:03:30
|
| Tried increase network package size in sp_configure? |
 |
|
|
aasimkhalid
Starting Member
2 Posts |
Posted - 2008-03-12 : 05:10:27
|
| I still cannot see where this limitation is being applied.Has anyone seen this behaviour on their implementation of Replication?RegardsThanks Aasim |
|
|
|
|
|
|
SQL 2005 Peer to Peer Replication bandwidth issue