Replication Issue
hi all,
i facing issue distributor subscriber , show history:-
retries attempted 0
message
2015-07-20 08:48:52.081 11 transaction(s) 20 command(s) delivered.
2015-07-20 08:49:02.127 24 transaction(s) 46 command(s) delivered.
2015-07-20 08:49:11.066 16 transaction(s) 30 command(s) delivered.
2015-07-20 08:49:20.894 21 transaction(s) 40 command(s) delivered.
2015-07-20 08:49:29.599 13 transaction(s) 22 command(s) delivered.
2015-07-20 08:49:54.153 25 transaction(s) 43 command(s) delivered.
2015-07-20 08:51:23.682 63 transaction(s) 90 command(s) delivered.
*******************************************************************************
2015-07-20 08:52:05.958 <stats state="1" work="2387" idle="881"><reader fetch="2" wait="1139"/><writer write="2387" wait="2"/><sincelaststats elapsedtime="341" work="277" cmds="1127" cmdspersec="4.000000"><reader fetch="0" wait="141"/><writer write="277" wait="0"/></sincelaststats></stats>
2015-07-20 08:52:05.958 ************************ statistics since agent started ***********************
07-20-2015 14:22:05
total run time (ms) : 3309670 total work time : 2387760
total num trans : 9664 num trans/sec : 4.05
total num cmds : 17836 num cmds/sec : 7.47
total idle time : 881333
writer thread stats
total number of retries : 0
time spent on exec : 2422076
time spent on commits (ms): 1035 commits/sec : 0.16
time apply cmds (ms) : 2387760 cmds/sec : 7.47
time cmd queue empty (ms) : 2853 empty q waits > 10ms: 199
total time request blk(ms): 884186
p2p work time (ms) : 0 p2p cmds skipped : 0
reader thread stats
calls retrieve cmds : 391
time retrieve cmds (ms): 410172 cmds/sec : 43.48
time cmd queue full (ms) : 731976 full q waits > 10ms : 34
2015-07-20 08:52:27.595 155 transaction(s) 282 command(s) delivered.
2015-07-20 08:53:04.895 108 transaction(s) 200 command(s) delivered.
2015-07-20 08:54:05.080 82 transaction(s) 152 command(s) delivered.
2015-07-20 08:55:14.235 48 transaction(s) 70 command(s) delivered.
2015-07-20 08:56:13.515 117 transaction(s) 227 command(s) delivered.
2015-07-20 08:57:31.749 61 transaction(s) 106 command(s) delivered.
*******************************************************************************
2015-07-20 08:57:31.749 <stats state="1" work="2750" idle="881"><reader fetch="2" wait="1465"/><writer write="2750" wait="2"/><sincelaststats elapsedtime="325" work="362" cmds="1037" cmdspersec="2.000000"><reader fetch="0" wait="325"/><writer write="362" wait="0"/></sincelaststats></stats>
2015-07-20 08:57:31.764 ************************ statistics since agent started ***********************
07-20-2015 14:27:31
total run time (ms) : 3635463 total work time : 2750447
total num trans : 10235 num trans/sec : 3.72
total num cmds : 18873 num cmds/sec : 6.86
total idle time : 881333
writer thread stats
total number of retries : 0
time spent on exec : 2747526
time spent on commits (ms): 1098 commits/sec : 0.14
time apply cmds (ms) : 2750447 cmds/sec : 6.86
time cmd queue empty (ms) : 2900 empty q waits > 10ms: 203
total time request blk(ms): 884233
p2p work time (ms) : 0 p2p cmds skipped : 0
reader thread stats
calls retrieve cmds : 403
time retrieve cmds (ms): 703361 cmds/sec : 26.83
time cmd queue full (ms) : 764580 full q waits > 10ms : 35
i don't know issue thinking issue on writing command on replicated server.
issue not occurred continuously sometime , when issue occurred active time 100% of disk, check through resource monitor. please let me know resolving issue.
my distribution database on subscriber .i have change disk distribution db , replication db , havent restart sql server in resource monitor show on same drive change drive system catalog.
thanks in advance
run blocked process report , let know blocking. distribution cleanup task.
but, normal , on busy systems expect blocking , have distribution cleanup task fail lot.
the message concerned replication command or batch of commands slow unknown reasons.
the blocking appears occurring on subscriber. investigate user processes blocking on subscriber opposed looking on publisher.
looking book on sql server 2008 administration? http://www.amazon.com/microsoft-server-2008-management-administration/dp/067233044x looking book on sql server 2008 full-text search? http://www.amazon.com/pro-full-text-search-server-2008/dp/1430215941
SQL Server > SQL Server Replication
Comments
Post a Comment