Export (0) Print
Expand All

Distribution Agent Profile

SQL Server 2000

Distribution Agent Profile

A default profile for the Distribution Agent is installed when a server is configured as a Distributor. The default profile contains the following parameters and values.

Default Value
-BcpBatchSize 100000 The number of rows to send in a bulk copy operation. When performing a bcp in operation, the batch size is the number of rows to send to the server as one transaction, and is also the number of rows that must be sent before the Distribution Agent logs a bcp progress message. When performing a bcp out operation, a fixed batch size of 1000 is used. A value of 0 indicates no message logging.
-CommitBatchSize 100 The number of transactions to be issued to the Subscriber before a COMMIT statement is issued.
-CommitBatchThreshold 1000 The number of replication commands to be issued to the Subscriber before a COMMIT statement is issued.
-HistoryVerboseLevel 1 The amount of history logged during a distribution operation can be:

1 = Always update a previous history message of the same status (startup, progress, success, and so forth). If no previous record with the same status exists, insert a new record.
2 = Insert new history records unless the record is for such things as idle messages or long-running job messages, in which case update the previous records.
3 = Always insert new records, unless it is for idle messages.

You can minimize the performance effect of history logging by selecting 1.

-LoginTimeOut 15 The number of seconds before the login attempted by the agent times out.
-MaxBcpThreads 1 The number of bulk copy operations that can be performed in parallel. The maximum number of threads and ODBC connections that exist simultaneously is the lesser of MaxBcpThreads or the number of bulk copy requests that appear in the synchronization transaction in the distribution database. MaxBcpThreads must have a value greater than zero, and has no hard-coded upper limit.
-MaxDeliveredTransactions 0 The maximum number of push or pull transactions applied to Subscribers in one synchronization. A value of 0 indicates that the maximum is an infinite number of transactions. Other values can be used by Subscribers to shorten the duration of a synchronization being pulled from a Publisher.
-PollingInterval 10 Number of seconds the distribution database is queried for replicated transactions.
-SkipErrors   The error number(s) that will be skipped. The Distribution Agent will ignore the error number(s) indicated and continue processing according to its schedule.
-SkipFailureLevel 1 The Distribution Agent is enabled to skip errors. A value of 0 indicates that the Distribution Agent will not ignore any errors.
-QueryTimeOut 300 The number of seconds before the queries issued by the agent time out.
-TransactionsPerHistory 100 The transaction interval for history logging. If the number of committed transactions after the last instance of history logging is greater than this option, a history message is logged. A value of 0 indicates infinite TransactionsPerHistory.

© 2014 Microsoft