Notes on Log Reader Parameters MaxCmdsInTran and ReadBatchSize

Notes on Log Reader Parameters MaxCmdsInTran and ReadBatchSize 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…

1