Step 1: Check Replication Features are installed
Step 2: Check if the Server is the Distributor
Step 3: Return a list of all Replication Log Reader Latency by Publication
The cntr_value for the Latency counter is defined in miliseconds. Default setting is 10000 (10 seconds). This must remain true for 10 minutes before the alert will fire. Please update these settings to meet your SLA's!
Latency could be increased due to a large number of commands being sent, please cross reference with the condition for commands.
The following link defines the counters available for monitoring Replication and their definitions: https://docs.microsoft.com/en-us/sql/relational-databases/replication/monitor/monitoring-replication-with-system-monitor?view=sql-server-2017
The following link shows how it is possible to send the commands for Stored Procedures across replication rather than the results. This can help to reduce the number of commands sent and therefore the latency, assuming that the surge in commands is the issue.
https://msdn.microsoft.com/en-us/library/ms152754.aspx
