I have two SQL Servers (2008 R2), and merge replication between them, one being the publisher and the other subscriber. I noticed that downloads are happening every minute, but uploads are happening every 10-15 minutes. I wonder why is this happening. There is very little activity on the subscriber, in average one change per minute. Does the subscriber batches uploads and only uploads them only when the batch reaches certain size? What can I do to determine the cause of this behavior.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top