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

I am using SQL 2012 with merge replication. Our setup is quite complicated and thus it seems running the publication with precompiled partitions is not going to work.

The merge agent is slow to do the first sync because of calling the sp_mssetupbelongs stored procedure.

I am wondering if it is viable to run the publication without precompiled partitions?

The first sync is faster without precompiled partitions, but subsequent syncs are a bit slower than before. Just a few changes will result in a sync of about 5 minutes.

I also tried an option called 'Optimize Partitions' and would like to know what this does? Deleting a record at the publication end did not propagate to the subscribers. The subsequent syncs were faster though. Why do deletes not propagate, and is there a workaround for this?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.