locked
How to monitor Sql replication lag RRS feed

  • Question

  • Hello, I found that I can run this statement on my database to see the last value for the replication lag. But are there tools to monitor that in the Portal and to get alerts if the lag reaches a certain threshold?


    SELECT   
         link_guid  
       , partner_server  
       , last_replication  
       , replication_lag_sec   
    FROM sys.dm_geo_replication_link_status;  
    Thanks

    Monday, November 27, 2017 9:19 PM

All replies