August 23, 2007 at 5:53 am
I am using SQL2000 with Merge Replication over a mobile broadband connection.On average the number of data changes issued is about 10,000
this can take up to 30 minutes in some instances.I know the connection speed will have a bearing - but is there anything I can do with the Replication properties that would help improve performances.
If a user has not replicated in a number of days the situation is a disaster.The merge process fails when cleaning up the meta data.
Any pointers greatly appreciated.
August 23, 2007 at 6:39 am
You have to change the settings in Merge_agent.
Try playing around with:
- ChangesPerHistory - Try setting this to an higher value like 300 (that cuts down the overhead)
- DownloadGenerationsPerBatch Set it to at least 500
- DownloadReadChangesPerBatch Set it to 200 or max 300, if you have a slow or unstable connection then set it to 10 or 20
- -DownloadWriteChangesPerBatch (set it to the same values as DownloadReadChangesPerBatch )
Do the same with UploadGenerationsPerBatch and UploadRe... and UploadWrite... settings
You have to do it on each single MergeAgent.
But you have to play around to find the right figures for your database and environment.
By the way, make sure that the MTU-Settings of your WAN connections are set properly (set it to a value which keeps the TCP-Packages from getting fragmented.)
August 23, 2007 at 6:45 am
thanks for that,I have already upped the changes per batch to 1000, not sure if it really made any difference.
Do you know if I can perform half (!) a sync. ie can I get the merge to upload
subscriber changes only .Then go back at a later stage and do a complete
merge ,upload and downloding from the publisher.
What are MTU-Settings
August 23, 2007 at 7:18 am
As I know, thats not possible.
1000 seems a bit to high. Try a lower value...
By the way, set the QueryTimeout to a very high value....
(MTU-Settings Maximum-Transfer-Unit is a windows setting) You could try the DFUE-Speed software freeware to set it right...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply