I am a replication rookie. We have a very simple transactional replication set up in SQL Server. I am looking at the Replication Monitor on the subscriber and one of my subscriptions show Poor Current Average Performance. My understanding is this is derived from the latency threshold but when I look at the detail of the subscription, Performance is Excellent and Latency is 00:00:00. For what it's worth, Synchronization Status is fine.
Why is this current average performance poor? Over what time period is this "average"? This subscription has had no noticeable issues and has been active for some time.
(I am asking for my own knowledge as well as ensuring there is not something broken/sub-optimal that should be modified)
Best Answer
Personally I ignore the excellent, poor, etc. As long as the number of records pending isn't very high, and the amount of time to catch up isn't very high I consider everything is fine. That front screen monitor is pretty misleading most of the time.