“Replication – Undistributed Command” is too general. It only tells me that a subscriber has a problem but it does not tell me exactly which publication the subscriber is having a problem with.
For example, the alarm for Undistributed Commands states that "Jon" is having an issue with a subscription. Ok... But which publication? Is it Sport illustrated, is it Motor Trend, etc.?
So I have to search through hundreds of publication on my own to find out which one the subscriber has and issue with. Is there a way for the alarm to identify exactly which publication a subscriber is having a problem with?
WORKAROUND: None
STATUS: Enhancement request has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.