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.
Transactional Replication log reader agent issue Delivering replicated transactions, xact count: 1, command count: 9472501
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.
Did you restart the log reader agent after you changed the MaxCmdInTran parameter?
Sign in to comment
Sort by: Most helpful