http://blogs.msdn.com/b/sqlcat/archive/2007/05/07/sql-server-2005-transactional-replication-benefit-of-using-subscriptionstreams-for-low-bandwidth-high-latency-environments.aspxAuthor: Bren Newman Introduction When using Microsoft SQL Server 2005 Transactional Replication, the Log Reader Agent reads the log, constructs SQL statements for published articles and posts it to the Distribution database; the Distribution Agenten-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlcat/archive/2007/05/07/sql-server-2005-transactional-replication-benefit-of-using-subscriptionstreams-for-low-bandwidth-high-latency-environments.aspx#10054045Wed, 25 Aug 2010 11:25:09 GMT91d46819-8472-40ad-a661-2c78acb4018c:10054045John Manson<p>Really good article and has just saved my behind! It looked like we would be waiting for 13 hours for our data to catchup, but using the really cool feature it was reduced to 4 hours.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10054045" width="1" height="1">http://blogs.msdn.com/b/sqlcat/archive/2007/05/07/sql-server-2005-transactional-replication-benefit-of-using-subscriptionstreams-for-low-bandwidth-high-latency-environments.aspx#5480655Wed, 17 Oct 2007 05:20:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:5480655SQL Server 開発チーム ブログ<p>マイクロソフトの植田です。 今回はレプリケーションに関する話題をご紹介したいと思います。 <a rel="nofollow" target="_new" href="http://blogs.msdn.com/sqlcat/archive/2007/05/07/sql-server-2005-transactional-replication-benefit-of-using-subscriptionstreams-for-low-bandwidth-high-latency-environments.aspx">http://blogs.msdn.com/sqlcat/archive/2007/05/07/sql-server-2005-transactional-replication-benefit-of-using-subscriptionstreams-for-low-bandwidth-high-latency-environments.aspx</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=5480655" width="1" height="1">http://blogs.msdn.com/b/sqlcat/archive/2007/05/07/sql-server-2005-transactional-replication-benefit-of-using-subscriptionstreams-for-low-bandwidth-high-latency-environments.aspx#2490984Wed, 09 May 2007 03:32:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:2490984Ira Pfeifer<p>Great stuff, I can immediately see applications for this in our environment. &nbsp;But I wanted to point out that your description of the results doesn't match up with Chart #1, and I was curious to know which was accurate.</p> <p>According to the text, 1 stream allowed a throughput of 6.86 cps at 512kbps/300ms, but the chart shows 31.54. &nbsp;If the chart is correct, the difference between 1 stream and 8 for a given bandwidth and latency is significant, but not the near 500% boost that you claim in the text. &nbsp;Either way, something doesn't match up. &nbsp;Can you please clarify?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=2490984" width="1" height="1">