SQL 2005 Peer to Peer Replication bandwidth issue

[TonyKhela]

Hi All,

I am setting up P2P replication for a high latency environment.

I have noticed that the bandwidth between Distribution and Subscriber servers maxes out at 1MBit per second (our network bandwidth is 100MBit per second).

Does anyone know where this limitation 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

TK

 

[TonyKhela]

I still cannot see where this limitation is being applied.

Has anyone seen this behaviour on their implementation of Replication?

Regards

 

[mrdenny]

Yes. SQL Server replication over a high latency network sucks. SQL Server replication maintains transactional integrity while it's running so it will only use up a small part of the pipe as it sends the commands one at a time.

What is the latency on your network pipe?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog