motioneye
asked on
distribution agent profile setting
I wonder in distribution agent profile, what can I do to optimize the agent to run better? I do have very often distribution slow due to very far replication between servers. as the screenshot attach I'm interested to know will these 2 setting able to maximize my distribution agent?
-CommitBatchSize has now values 5000 should I increase or decrease when I have slow replication performance? it says the number of transactions what is that means here?
-BcpBatchSize has default values 100000 I think this only useful when we have 100k rows to be replicate simultaneous
profile.bmp
-CommitBatchSize has now values 5000 should I increase or decrease when I have slow replication performance? it says the number of transactions what is that means here?
-BcpBatchSize has default values 100000 I think this only useful when we have 100k rows to be replicate simultaneous
profile.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.