Sateesh Yele | Microsoft SQL Server Support Peer-2-Peer Replication Wizard provides no options to enable table partition switching. There are 2 ways to enable this feature. 1) create the publication on ALL the peers using TSQL sp_addpublication 2) create the subscriptions using the user interface — or — 1) create the publication using the Replication
Read More »
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 »
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 »