In live environment, I have published 5 databases from MAIN-DB to REP-DB using PULL transactional replication.
When I open replication monitor in MAIN-DB, I see that 4 subscriptions have latency of a few seconds.
But one subscription has very high latency (14:10:34), and the status is "Performance critical".
I see that from replication monitor:
1) "Publisher To Distributor History" is running and last action message is "Delivering replicated transactions, xact count: 341, command count: 401".
2) "Distributor To Subscriber History" is running and last action message is "No replicated transactions are available."
3) "Undistributed Commands" shows number of commands waiting to be applied to subscriber = 0
I tried to use post tracer token to check the latency, but the result from sp_helptracertokenhistory shows NULL in both distributor_latency and subscriber_latency.
What should I do? Should I restart some of the agents? If so, which agent should I restart?