Ò»¸ö·¢²¼ ÓÐ5¸ö¶©ÔÄ£¬ 3¶©ÔÄÊÇÍøÕ¾·þÎñÆ÷£¬2¸ö¶©ÔÄ·Ö±ðÊÇA¡¢B£¬Êǹ«Ë¾¹ÜÀíϵͳ·þÎñÆ÷£¬½ñÌìͻȻ·¢ÏÖA¡¢B 2¸ö¶©ÔÄ·þÎñÆ÷ ³¬Ê±ÑÏÖØ,AÊÇ18·ÖÖÓ£¬BÊÇ3·ÖÖÓ£¬¶øÁíÍâ3¸öûÓÐÎÊÌ⣡

ºóÀ´ÎÒÓÖÕÒÁËһ̨·þÎñÆ÷ C ¼ÓÈ붩ÔÄ£¬°Ñ³¬Ê±×ÖصķþÎñÆ÷A£¨³¬Ê±18·ÖÖÓ£© µÄÓ¦ÓÃÁ´½Óȫתµ½C·þÎñÆ÷ÉÏ¡£ ÓÖ°ÑAÖØÆðÁËһϣ¬½á¹ûA»¨Á˽üÒ»¸öСʱµÄʱ¼ä£¬²Å²»³¬Ê±¡£Í¬²½ºó£¬·¢
ÏÖż¶øA»ú»¹ÊÇ»á³öÏÖ³¬Ê±£¬ ÏÖÔÚ¹«Ë¾¹ÜÀíϵͳһ¹²ÊÇA B C Èý̨Êý¾Ý¿â·þÎñÆ÷¡£
ÎÊÌ⣺
1¡¢ÎªÊ²Ã´Ò»¸ö·¢²¼£¬»á³öÏÖÓеĶ©ÔÄÕý³££¬ÓеĶ©Ôij¬Ê±£¿
2¡¢A·þÎñÆ÷ÔÚûÓбðµÄÓ¦ÓõÄÇé¿öÏ£¬ÎªÊ²Ã´ÐèÒªÕâô³¤µÄʱ¼ä²ÅÄÜͬ²½£¿
3¡¢Èç¹ûÎÒÒª½øÐвéÕÒÔ­Òò£¬Ó¦¸ÃÔõô×ö£¿

²é¿´µ½ÈÕÖ¾£º

ÏûÏ¢
¸´ÖÆ´úÀíÓöµ½´íÎó£¬ÆäÉèÖÃÊÇÈÃËüÔÚ×÷Òµ²½ÖèÖØÊÔ¼ä¸ôÄÚÖØÐÂÆô¶¯¡£ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄÉÏÒ»¸ö×÷Òµ²½ÖèÀúÊ·¼Ç¼ÏûÏ¢»ò¸´ÖƼàÊÓÆ÷¡£
ÏûÏ¢
-commitbatchsize 100
-commitbatchthreshold 1000
-historyverboselevel 1

ÏûÏ¢
Time Cmd Queue Full (ms) : 912863 Full Q Waits > 10ms : 139
*******************************************************************************

2008-03-28 03:40:54.218 ÕýÔڶϿªÓë ¶©ÔÄ·þÎñÆ÷¡°JDUSERDB

Did you check cpu usage and network i/o on that server? Any message in
replication agent and sql server log?

"fan" wrote: