Report for amount of data replicated

• Evan D Roberts

  Grasshopper

  Points: 12

  More actions

  April 18, 2005 at 7:11 am

  #87288

  Hello All,

  I have approximatly 50 databases (and growing) replicated to customers via merge replication. Replication happens every hour on the hour from 7PM to 5AM.

  I would like to see a report showing how much data was exchanged between my site and each customer per day (not replication cycle). If it broke it down by table that would be great.

  Is there a canned report or public domain script?

  Thanks in advance for any and all help,

  ER

• jmcgarvey

  Default port

  Points: 1489

  More actions

  April 18, 2005 at 9:10 am

  #553204

  At best here is a starting point.  Run this on the distribution db associated with your replication. 

  use distribution

  go

  select start_time,

   duration as [Seconds],

   rtrim(comments) as comments,

   current_delivery_rate as Avg#CmdsSec,

   current_delivery_latency,

   delivered_transactions,

   delivered_commands,

   average_commands,

   delivery_rate as CmdsSec,

   delivery_latency,

   total_delivered_commands

  From MSdistribution_history

  where current_delivery_rate > 0.0

   

  For additional information on the MSdistribution_history

  table look in Books On Line.

   

  Good Luck

  John