I'm thinking of dropping the polling interval to 30 seconds. What is
the behaviour of the merge agent if it takes longer than 30 seconds to
synchronize enumerated changes fo a session?

Polling interval refers to how long the agent will wait when running in
continuous mode to check to see if there have been any changes.

Its better to get small batches, however there is some over head with this;
so its a matter of finding out what works best with your machine.

Moving it from the default of 60 to 30 on a high throughput system is
generally a good thing. On a smaller throughput system (less changes) it
won't do much.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]