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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Merge replication is the gift that keeps on giving as far as throwing new things at us, and the latest is a subscription that had been behaving for quite sometime suddenly slowing to a crawl.

This manifested first as being stuck on 'Uploading data changes to the Publisher'. Eventually it indicated progress, there was much rejoicing. Then a very long wait and another indication of progress, then nothing for a long time (2+ hours now).

In the profiler, there is activity (albeit slow) from the pull subscriber. In this activity, a lot of conflicts.

The only other (seeming?) lead is in the MSmerge_genhistory table on the subscriber there are a lot of 'genstatus = 4' (interrupted) generations. Only one has genstatus = 0. There doesn't seem to be any motion there.

Is there something else we should be looking at? Any further info I could provide that would help diagnose? We are loathe to reinitialize or delete and re-create as this is a publication that is large enough in our environment that these processes take many hours and we are getting considerable pressure to resolve soon.

Thanks. S


migration rejected from Sep 27 '13 at 17:13

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by Max Vernon, dezso, Paul White, RolandoMySQLDBA, Kin Sep 27 '13 at 17:13

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

Is this over Web Synchronization? – Brandon Williams Sep 6 '13 at 15:39