We have a Web Synchronization for merge replication system (67 tables, 55 of them should be Download-Only. Lots of them Dynamic Filter, and 10 of them have Join Filters) between sql server 2008 R2 (as publisher) and sql server express 2008 R2 (800 pull subscriptions
with only web synchronization, with 3G connection). I googled for all of today about performance tips and tricks, and set our profiles, settings etc..
My problem is at initial synchronization process. First of all after Creating Replication triggers (before this other snapshot scripts are being applied) at Initial Web Sync Process, we wait 5-15 minutes after last ".. creating replication triggers
on table 'tblOrder' message. I think after creating replication triggers, Merge Agent connects to Web Sync Replisapi.dll and it computes the data needed, but this takes too long 5-15 minutes??
And after these download operations, after all necessary data is downloaded, i think merge agent is starting to download the snapshot. Why this is necessary? because before the initial synchronization, i create all tables manually, and after that i create
merge subscription manually. And then, starting merge process, snapshot is being applied to subscription database, necessary data is being downloaded so why the whole data is being downloaded after data transfer again? It takes too long
View Complete Post