Tag: MaxBCPThreads

Improve Snapshot Performance by changing MaxBcpThreads

ReplTalk Inside Replication, Try This June 14, 2010

content provided by: Akbar Farishta, Technical Lead, Microsoft SQL Server Support I wanted to post an update to Snapshot Agent Performance –MaxBCPThreads blog posting. We recently encounter a performance problem trying to push a 120gig snapshot down to a subscriber. The Distribution Agent was taking a long time doing a Bulk Insert on an 80gig
Read More »

Snapshot Agent Performance –MaxBCPThreads

Chris Skorlinski [MSFT] Inside Replication, Try This May 9, 2010

We noticed a large published database was taking a long time for the Snapshot to be applied to the subscriber. Looking further in sp_who and sys.sysprocesses we noticed only one Distribution Agent thread executing the bulk insert statements. It took a while but we discovered the publication was created using “concurrent snapshot” option. -MaxBcpThreads number_of_threads
Read More »

Tips to improve performance when applying Snapshot in Transactional Replication

Chris Skorlinski [MSFT] Best Practices, Troubleshooting March 7, 2010

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 »