Category: Try This

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 »

Walkthrough Setting up a SQL 2008 Replication Distributor using TSQL Scripts

Share this PostIn this video •Configuring Distributor is first step in setting up SQL Server Replication •We verify Distributor is not configured •Walkthrough setting up SQL Replication Distributor using TSQL Scripts •Highlight of key parameters •Show how to generated Distributor TSQL commands automatically from SQL Server Management Studio Remember, you can double-click the video to
Read More »

Walkthrough Setting up SQL 2008 Peer-2-Peer Replication

Share this PostSudharshan Prahallada, Microsoft SQL Replication Support team walks through setting up Peer-2-Peer Transactional Replication on SQL 2008.  You can view this video from the BLOG or double-click to open in YouTube.  He did a great job showing the Peer-2-Peer Wizard and explaining how it all comes together in a 5 minute video. For
Read More »