Cause identified to be an issue with the value from the Stored Procedure used for collection.
The 'timetoexpiration' value from stored procedure 'distribution.dbo.sp_replmonitorhelpsubscription', used for this collection. According to Microsoft documentation, the "Is the length of time, in hours, before the subscription expires if not synchronized" is used. It was idenfied that this metric doesn't show expected value.
WORKAROUND:
Disable Alarm 'Replication - Subscription Expiration' or change Alarm severity threshold to 9999.
STATUS:
Waiting for fix to be released in a future version of Spotlight on SQL Server Enterprise.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center