Log Reader question | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Log Reader question

Hi, Is there any connection (looking for performance site) between LOG READER and Retension Period Time? I see that when I’ve change retension period from 2 days to 4 days Log Reader is having problems and I see errors like – ‘could execute sp_replcmds on…The step was retrying 10 times without succeeding’ If I change ReadBatchSize (from 500 to 1) for Log Reader agent is workig fine but I want to keep 500 value for ReadBatchSize. Any ideas?
See this KBA
http://support.microsoft.com/kb/308865
http://support.microsoft.com/kb/811030 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>