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

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

**********************************************************************