All Publishers Discovered for Distributor

Microsoft.SQLServer.Replication.Core.Monitor.DistributorAllPublishersDiscoveredMonitor (UnitMonitor)

This monitor checks that all Publishers are discovered for the Distributor.

Knowledge Base article:

Overrideable Parameters

Name	Description	Default Value
Alert Priority	Defines Alert Priority.	Normal
Alert Severity	Defines Alert Severity.	Warning
Enabled	Enables or disables the workflow.	Yes
Generates Alerts	Defines whether the workflow generates an Alert.	Yes
Interval (seconds)	The recurring interval of time in seconds in which to run the workflow.	300
Synchronization Time	Synchronization Time
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	200
Timeout for database connection (seconds)	The workflow will fail and register an event, if it cannot access the database during the specified period.	15

Element properties:

Target

Microsoft.SQLServer.Replication.Core.VirtualDistributor

Parent Monitor

System.Health.ConfigurationState

Category

PerformanceHealth

Enabled

True

Alert Generate

True

Alert Severity

Warning

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

Microsoft.SQLServer.Replication.Core.MonitorType.DistributorAllPublishersDiscoveredMonitorType

Remotable

True

Accessibility

Internal

Alert Message

MSSQL Replication: Incorrect count of discovered Publishers.

The Distributor (Name: '{0}', Server: '{1}') has detected incorrect count of discovered Publishers.
{2}

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.Replication.Core.Monitor.DistributorAllPublishersDiscoveredMonitor" Accessibility="Internal" Enabled="true" Target="Microsoft.SQLServer.Replication.Core.VirtualDistributor" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.Replication.Core.MonitorType.DistributorAllPublishersDiscoveredMonitorType" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.Replication.Core.Monitor.DistributorAllPublishersDiscovered.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Warning</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.VirtualDistributor']/InstanceName$</AlertParameter1>

      <AlertParameter2>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.VirtualDistributor']/ConnectionString$</AlertParameter2>

      <AlertParameter3>$Data/Context/Property[@Name='Message']$</AlertParameter3>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Health" MonitorTypeStateID="Health" HealthState="Success"/>

    <OperationalState ID="Warning" MonitorTypeStateID="Warning" HealthState="Warning"/>

  </OperationalStates>

  <Configuration>

    <MachineName>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.VirtualDistributor']/MachineName$</MachineName>

    <NetbiosComputerName>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.VirtualDistributor']/NetbiosComputerName$</NetbiosComputerName>

    <InstanceName>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.VirtualDistributor']/InstanceName$</InstanceName>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

    <ConnectionString>$Target/Property[Type='Microsoft.SQLServer.Replication.Core.VirtualDistributor']/ConnectionString$</ConnectionString>

    <PublisherClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericPublisher']$</PublisherClassId>

    <IntervalSeconds>300</IntervalSeconds>

    <SyncTime/>

    <TimeoutSeconds>200</TimeoutSeconds>

  </Configuration>

</UnitMonitor>