I currently have several Merge replication topologies synchronizing over the Web and have the Merge Agent(s) scheduled to run every 1 minute which I assume is equivalent to running the Merge Agent in continuous mode since the default -PollingInterval parameter
is 60 seconds. Recently I've been getting complaints that even 1 minute isn't frequent enough to meet my customers' needs.
I'm curious if there could be any issues that may arise with scheduling the Merge Agent to run every 15 or 30 seconds
or running the Merge Agent in continuous mode with the -PollingInterval set to 15 or 30 seconds? Does anyone have experience running the Merge Agent on this frequent of a schedule over the Web and if so, how were your results?
I think I should also mention that the average duration of synchronization in one of the topologies is approximately 30 seconds - 1 minute and 30 seconds.
Thanks in advance.
View Complete Post