SQL Server replication - Log Reader Agent Read Latency Issue, Please help
Posted
by
envykok
on Server Fault
See other posts from Server Fault
or by envykok
Published on 2011-03-02T02:00:16Z
Indexed on
2011/03/02
7:26 UTC
Read the original article
Hit count: 580
Hi all, I am facing one transactional replication delay issue on log reader agent.
The log reader output is :
********* STATISTICS SINCE AGENT STARTED ************** 02-28-2011 20:12:08
Execution time (ms): 304141 Work time (ms): 304016 Distribute Repl Cmds Time(ms): 303764 Fetch time(ms): 300813 Repldone time(ms): 1826 Write time(ms): 5319 Num Trans: 15500 Num Trans/Sec: 50.984159 Num Cmds: 191639 Num Cmds/Sec: 630.358271
It seems Log Reader Reader-Thread Latency, and I also run 'sp_replcounters' and see more than 20,000 sec replication latency and keep on increasing.
I used SQL profiler to monitor sp_replcmds and found sp_replcmds execution time was 11 sec to 15 sec
Is it there any way to optimize to make Log Reader read faster from transaction log???
Other information:
SQL Server 2008 (SP2) Standard 64 bit
© Server Fault or respective owner
