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

This article was previously published under Q299787
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 352051 (SHILOH_BUGS)
SYMPTOMS
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.
CAUSE
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.
RESOLUTION
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 theMicrosoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
WORKAROUND
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.
STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
MORE INFORMATION
Here is an example of the replication statistics taken from a Distribution agent's output file:

**********************************STATISTICS**************************Distribute Repl Cmds Time (ms): 343Num Trans: 10  Num Trans/Sec: 29.154519Num Cmds: 230  Num Cmds/Sec: 670.553936Get Repl Cmds Time: 250  Trans/Sec: 40.000000Add Dist Cmds Time: 343   Trans/Sec: 29.154519Empty Command Request Time: 0Full Command Request Time: 250Wait For Last Full Command Time: 93**********************************************************************				
Properties

Article ID: 299787 - Last Review: 01/16/2015 22:46:14 - Revision: 3.2

  • Microsoft SQL Server 2000 Standard Edition
  • kbnosurvey kbarchive kbbug kbfix kbsqlserv2000sp1fix KB299787
Feedback