Latency is the time it takes for the data to replicate at the subscriber once it updates the primary.

Reason for latency

  1. When DSI thread is down
  2. When huge batch jobs running on the primary database.
  3. When blocking at replicate
Read the rest