?
Solved

distribution agent profile setting

Posted on 2008-10-06
1
Medium Priority
?
418 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

762 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