?
Solved

distribution agent profile setting

Posted on 2008-10-06
1
Medium Priority
?
448 Views
Last Modified: 2011-10-19
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
0
Comment
Question by:motioneye
1 Comment
 
LVL 37

Accepted Solution

by:
momi_sabag earned 1500 total points
ID: 22657032
BcpBatchSize is only relevant for bcp operations on the source table and not regular update operations (insert / update / delete) so i don't know if that parameter will help you (unless you have many bcp operations)

CommitBatchSize - if you have a very busy environment, you might consider increasing the value of this parameter in order to reduce the overall number of commit operations, but i would not decrease this value unless you have a very few updates in the source envrionment
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

584 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question