Transactional Replication log reader agent issue Delivering replicated transactions, xact count: 1, command count: 9472501

kiran Prasad 1 Reputation point
2022-04-05T18:55:25.287+00:00

In log reader agent it is showing like below, not sure why i am seeing this error, i have re initialized and re created the replication still the issue persist.
Replication Log reader agent showing "Delivering replicated transactions, xact count: 1, command count: 9472501"
I have changed the log reader agent parameters -readbatchsize 7000 -pollinginterval 1000 -MaxCmdsInTran 7000 -ReadBatchThreshold 7000 still the issue persist. Are these setting valid, help would be appreciate.

-ReadBatchThreshold 7000
-readbatchsize 7000
-MaxCmdsInTran 7000
-pollinginterval 1000
-OutputVerboseLevel 2
-Output F:\Temp\Logreader_Agent.log
-Continuous

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,808 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,558 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2022-04-06T16:22:43.17+00:00

    When you have large numbers of commands like you have, it is best to set the MaxCmdInTran to a very small number, like 10 or 100, at least until it catches up.

    0 comments