{"tsql":"create table #replcounters\r\n([Database] sysname,\r\n[Replicated transactions] int,\r\n[Replication rate trans\/sec] float,\r\n[replication latency (sec)] float,\r\nReplbeginlsn binary(10),\r\nReplnextlsn binary(10));\r\nINSERT INTO #replcounters\r\nEXEC sp_replcounters;\r\nSELECT t.[replication latency (sec)]\r\nFROM #replcounters as t;\r\ndrop table #replcounters;","instances":false,"databases":{"mode":1},"frequency":300,"metricenabled":true,"alertenabled":false,"alertname":"Replication Latency Too High","alertdescription":"This database has experienced high dispatch latency in replication","aboveorbelow":"above","_thresholds_high":{"selected":true,"value":10},"_thresholds_medium":{"selected":true,"value":5},"collections":1,"frequency_comment":"seconds (collected every 5 minutes)","rateofchange":false,"_thresholds_low":{"selected":false},"targetentitytype":0}