Category: Try This

Executing batch UPDATE commands on Publisher and its affect on Transactional Replication

Share this PostJosé Moreira Neto | Microsoft SQL Server Escalation Services Problem 1: batch updates 1)      A single update command can generate a transaction with thousands of commands. For example if you execute an UPDATE statement that updates 10K rows on the publisher, up to 20K commands can be send over to the subscriber. On
Read More »

Tune Replication Performance using PacketSize

Share this PostContributed 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
Read More »

Divide and Conquer Transactional Replication using Tracer Tokens

Share this PostAs we know, Transactional Replication moves data from the Publisher to the Distributor then to the Subscribers.  When working, data flows near real-time through both of these steps.  When problems occur which interrupt this flow, latency is introduced.  The challenge is to find which step is contributing to the overall latency.  Tracer Tokens
Read More »