The Log Shipping - Secondary Latency alarm is raised when the amount of time that elapsed between the log backup being created on the primary database and when it was restored on the secondary database exceeds a threshold.
When this alarm is current, it may indicate a problem in getting data from the primary database to the secondary database. Looking at the history of the copy or restore job may help identify the problem. To do this, go to the Secondaries page of the High Availability drilldown and select an item in the grid to view the history.
Tips:
You can configure different alarm severities for specific secondary databases. See "Configure Keyed Alarms" (page 1) for more information. The key for this alarm is the ID of the secondary database. You can see this information in the Transaction Log Shipping Secondaries grid on the Secondaries page of the High Availability drilldown.
The Primary ID column may be hidden by default. See Show, Hide & Order Columns (page 1) for more information on how to display hidden columns.
