Microsoft KB Archive/299787

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

Article ID: 299787

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q299787



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 the Microsoft 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): 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



Keywords: kbbug kbfix kbsqlserv2000sp1fix KB299787

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.