Author: ReplTalk

Troubleshooting Error: The merge process was unable to perform data validation on article

Sateesh Yele | Microsoft SQL Server Support I would like to share information about an interesting Replication issue I recently worked. Customer was getting unusual error messages during synchronization. Symptom: Merge agent is failing with the following error message when validating large tables with checksum. The merge process was unable to perform data validation on
Read More »

Tune Replication Performance using PacketSize

Contributed by: Karol Korasadowicz Depending on type of data being replicated and network throughput adjusting the PacketSize parameter for the Distribution Agent may increase your overall Transactional Replication performance. -PacketSize packet_size Is the packet size, in bytes. The default is 4096 (bytes). http://msdn.microsoft.com/en-us/library/ms147328.aspx To see which setting has most impact, create test scenario which inserts/updates
Read More »

All about “Identity Range Management”

José Moreira Neto | SQL Server Escalation Services Automatic Identity Range Management Microsoft SQL Server automatically generates sequential numbers for new rows inserted in the table containing the identity column. Identity columns are normally included as part of Primary Keys, therefore the need to avoid duplicates. To use identity columns in a replication topology that
Read More »

Navigating SQL Replication SubscriptionStreams setting

Rishi Maini | Microsoft SQL Escalation Services This blog posting discusses the new Distribution Agent SubscriptionStreams parameter.  This option reduces the latency when moving data from Distributor to Subscriber by using multiple parallel writer threads.  For more information on Replication “threads” see Transactional Replication Conversations blog posting. From SQL Books Online (good place to start)
Read More »