Latency problems are often caused when series of transactions are trying to move a large batch of commands from the Publisher to the Distributor to the Subscribers. The queries below show overall rows counts and index statistics for commands stored in the Distribution database. Use the results of these queries to look for unexpected high-volume
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 »
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 »
Rishi Maini | Microsoft SQL Server Escalation Services All about “Not for Replication” “Not for Replication” is a property which can be set for different objects like Check constraints, Foreign Key constraints, Triggers , Identity columns etc while using SQL Server Replication. Feature used when the DBA would like the transactions to behave differently when
Read More »