为分发服务器发现的所有发布服务器

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

此监视器将检查是否已为分发服务器发现所有发布服务器。

Knowledge Base article:

可替代参数

名称	说明	默认值
警报优先级	定义警报优先级。	正常
警报严重性	定义警报严重性。	警告
已启用	启用或禁用工作流。	是
生成警报	定义工作流是否生成警报。	是
间隔(秒)	运行工作流的重复间隔时间(秒)。	300
同步时间	同步时间
超时(秒)	指定允许工作流在被关闭并标记为失败之前运行的时间。	200
数据库连接超时(秒)	如果在指定期间无法访问数据库，工作流将失败并注册一个事件。	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 复制: 发现的发布服务器计数不正确。

分发服务器(名称:“{0}”，服务器:“{1}”)已检测到已发现的发布服务器的计数不正确。
{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>