FIX: Skewed Replication Statistics in Output File When Running Agent Continuously

Article translations Article translations
Article ID: 299787 - View products that this article applies to.
This article was previously published under Q299787
BUG #: 352051 (SHILOH_BUGS)
Expand all | Collapse all


Transactional replication statistics are printed in the Replication agent output file at the end of a replication session. When the Logreader or Distribution agent run on a continuous schedule, delivery rate statistics such as Cmds/sec and Trans/sec may become skewed and may not be fully accurate.

Replication statistics reported by Enterprise Manager are not affected by this behavior. This problem only occurs for replication statistics in the Replication agent's output file.


The statistics generated in the agent's output file take into account any idle time for the Replication agent; therefore, the Cmds/sec and Trans/sec statistics are lower than their actual values.


To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack


You can work around this problem in either of the following ways:
  • Use the sp_replcounters stored procedure to obtain replication statistics information. For more information, see SQL Server 2000 Books Online. -or-

  • Use a recurring schedule instead of the continuous schedule for the Replication agent.


Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.


Here is an example of the replication statistics taken from a Distribution agent's output file:


Distribute Repl Cmds Time (ms): 343

Num Trans: 10  Num Trans/Sec: 29.154519

Num Cmds: 230  Num Cmds/Sec: 670.553936

Get Repl Cmds Time: 250  Trans/Sec: 40.000000

Add Dist Cmds Time: 343   Trans/Sec: 29.154519

Empty Command Request Time: 0

Full Command Request Time: 250

Wait For Last Full Command Time: 93



Article ID: 299787 - Last Review: November 5, 2003 - Revision: 3.2
  • Microsoft SQL Server 2000 Standard Edition
kbbug kbfix kbsqlserv2000sp1fix KB299787

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from