How much data is transfered during replication

• Lewis Lebron-139458

  Newbie

  Points: 1

  More actions

  August 5, 2004 at 9:33 am

  #83463

  Hello, I have a quick question. I have one way trans replication job setup between two db's at an interval of every 10 minutes. What I want to know is how can I tell how much data in kb or mb is being transfered at every interval? I looked at the history of the distribution agent, but it only tells me the latency, time and number of commands. Any help is greatly appreciated. This is a wonderful forum with so much info.

  Lewisl77

• David.Poole

  SSC Guru

  Points: 76213

  More actions

  August 5, 2004 at 10:05 am

  #517872

  It depends which table or tables have altered transactions.

  You could have a table with two tinyint fields or you could have a table with 8060 bytes per record which includes some 2Gb text files!

  Two options spring to mind.

  • SQL Profiler.
  • A network diagnostic tool to monitor network traffic between the two SQL Servers.

  LinkedIn Profile