Tag: sp_MSmakegeneration

Reducing Impact of Large Updates on Merge Replication

One key parameter to consider when performing batch updates against tables enabled for Merge Replication is ‘generation_leveling_threshold’.  This setting controls how many data changes should be grouped into one generations (or batch).  The Merge Agent then collect and sends those batches of changes based on the Merge Agent [-DownloadGenerationsPerBatch] parameter.  The default is to group
Read More »