Solved

distribution agent profile setting

Posted on 2008-10-06
1
413 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 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

691 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