Tag: MaxBCPThreads

Snapshot Agent Performance –MaxBCPThreads

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

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 »