Hi all,

I am assigned the task to find out the latency between the transactional replication from the publisher to the subscriber.

I had tried to check out on the Distribution database, MSdistribution_history table but the duration is not for the current transaction but on an accumulative basis starting from the time the table is published for replication.

Any help is very much appreciated. Thanks