Did you know that Pull replication performs much better than Push?
When replicating data over a WAN (Wide Area Network) using Transactional Replication you can improve the transactions delivery rate just by having the Distribution Agent located at the Subscriber (Pull) instead of having the Distribution Agent located at the Distributor (Push).
In an upcoming post I will talk more about that.
The bellow table shows the results of a test I have done over a 160 ms WAN with one server located at NY and the other at TLV.
Both servers are running SQL Server 2005 sp2 build 3282 (CU6) x64 with similar HW.
Type | Status | Transactions | Commands | Sec Delivered | Trans/Sec |
| Push | 17 | 40000 | 40000 | 430 | 93 |
| Pull | 17 | 40000 | 40000 | 205 | 195 |
To leave a comment pls follow this link: http://blogs.microsoft.co.il/blogs/yaniv_etrogi/archive/2009/02/25/pull-replication-vs-push-replication.aspx
-Yaniv
=================================================
