See how far Replication has got

• Shark Energy

  SSCrazy Eights

  Points: 8389

  More actions

  October 1, 2008 at 4:16 am

  #72890

  Hi all,

  I want to see how far my distribution agent has got. Replicating 3,000,000 records across the network. Tried looking at loads of info but can't work out how much longer it has left to run, but I need to provide an estimate.

  Cheers,

  Shark

• Shark Energy

  SSCrazy Eights

  Points: 8389

  More actions

  October 1, 2008 at 4:53 am

  #879391

  Other questions -

  I had 1.4 million records transfer at 100000 commands per second, yet it took 3 hours to get through?!?

  I do replication from Server A to B to C. The job populating A did 2 batches, one of 1.6 million and one of 1.4 million. The repl from A to B seemed to group this into 3 million commands. However, the repl from B to C did 1 batch of 1.6 WHILST A to B was still running, and then the 1.4 seperate once A to B had finished.

  Can someone explain to me how this worked?

  Thanks tons!