This week, a customer of mine shared the image below, mentioning that their Snapshot Replication is experiencing bad performance.
The customer informed me that the snapshot replication was operating correctly. I then inquired whether the tables being replicated had increased in size, to which they responded affirmatively. Consequently, I recommended that they utilize a smaller BcpBatchSize value in the Snapshot Agent Profile. I recommended that they reduce the BcpBatchSize setting from its default value of 100000 to 50000 rows. This can be done by creating a new agent profile derived from the default profile, adjusting the BcpBatchSize value to 50000, and subsequently assigning this new profile to the Snapshot Publication.
Lowering it can reduce memory usage and improve stability for large datasets, though it may slow down snapshot generation.
No comments:
Post a Comment