As 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 help you
Read More »
1) MaxBCPThreads (contributed by Sanjaya Padhi, Microsoft SQL Server Support) I found we can add in the below point to increase the perf of the snapshot application by the distribution agent by use of MaxBCPThreads parameter as mentioned in the article below. Please note this does not apply when Snapshot created using default “concurrent” option.
Read More »
Satesh Yele | Microsoft SQL Server Support Quick collection of links for getting started with Transactional Replication. Transactional Replication http://msdn.microsoft.com/en-us/library/ms165720(SQL.90).aspx How Transactional Replication Works http://msdn.microsoft.com/en-us/library/ms151706(SQL.90).aspx Considerations for Transactional Replication http://msdn.microsoft.com/en-us/library/ms151254(SQL.90).aspx Replication Security Best Practices http://msdn.microsoft.com/en-us/library/ms151227(SQL.90).aspx Implementing Replication http://msdn.microsoft.com/en-us/library/ms151847(SQL.90).aspx SQL Server Replication (How Do I) http://msdn.microsoft.com/en-us/library/ms166348(SQL.90).aspx Configuring Distribution http://msdn.microsoft.com/en-us/library/ms151860(SQL.90).aspx How to: Configure Distribution (SQL Server Management
Read More »
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 »
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 »