SQL Server Performance Forum – Threads Archive
Log Reader questionHi, 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/811030 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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.