replication latency

Question

how to find the latency in replication .................

---

pradeep kumar reddy

Answer 1

I think it is varies b/w different types of replication and need to measure the latencey -Iam not much aware of replication but the below can help you-

 Measuring latency for Transactional Replication
http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/3591d1b8-84b1-48ef-af59-59cbf7e746eb

http://blogs.msdn.com/b/repltalk/archive/2010/02/21/transactional-replication-conversations.aspx

---

Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Answer 2

Open replication monitor and test from there. It will send some tokens to the target and after receiving it will calculate how much time taken. Is it what you looking for?