Tag: ReadBatchSize

Notes on Log Reader Parameters MaxCmdsInTran and ReadBatchSize

ReplTalk Best Practices, Inside Replication October 8, 2012

Jose Moreira B. Neto Microsoft SQL Server Escalation Services From SQL Server BOL we have: -ReadBatchSize Is the maximum number of transactions read out of the transaction log of the publishing database per processing cycle, with a default of 500. -MaxCmdsInTran Specifies the maximum number of statements grouped into a transaction as the Log Reader
Read More »