Monitor Replication

• BiboKid

  Mr or Mrs. 500

  Points: 562

  More actions

  March 14, 2017 at 8:01 pm

  #401788

  Hi!

  Im new in replication and not sure how if ai can produce this.Can someone please help me on how to query latency of all replication publications including all replicated databases in the database servers ?

  Thank you!

• Ricky Valencia

  SSCommitted

  Points: 1907

  More actions

  March 14, 2017 at 8:57 pm

  #1933169

  Hi Bibo Kid,

  These links might help you. 

  -- Monitoring SQL Server Transactional Replication
  https://www.brentozar.com/archive/2014/07/monitoring-sql-server-transactional-replication/

  -- Monitor Replication Using Scripts
  https://www.sqlservercentral.com/Forums/605381/Monitor-Replication-Using-Scripts

  --Checking Replication Latency with T-SQL
  http://sqlfool.com/2008/11/checking-replication-latency-with-t-sql/

  Best Regards,
  Ricky