MSSQL: универсальное обнаружение работоспособности базы данных репликации

Microsoft.SQLServer.Replication.Core.Discovery.DatabaseHealth (Discovery)

Обнаружение объектов находит контейнеры агрегатов работоспособности и связи для объектов, связанных с опубликованной базой данных.

Knowledge Base article:

Сводка

Переопределяемые параметры

Имя	Описание	Значение по умолчанию
Включено	Включает или отключает рабочий процесс.	Да
Интервал (в секундах)	Повторяющийся интервал времени в секундах, в который следует запустить рабочий процесс.	14400
Время синхронизации	Время синхронизации
Время ожидания (в секундах)	Время ожидания (в секундах)	15
Время ожидания (в секундах)	Указывает время, в течение которого рабочий процесс должен быть запущен, прежде чем он будет закрыт и отмечен как завершившийся сбоем.	300

Element properties:

Target	Microsoft.SQLServer.Replication.Core.Seed
Enabled	True
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.Replication.Core.DatabaseHealth Microsoft.SQLServer.Replication.Core.VirtualDistributor Microsoft.SQLServer.Replication.Core.VirtualPublicationHost Microsoft.SQLServer.Replication.Core.VirtualPublisher Microsoft.SQLServer.Replication.Core.VirtualSubscriber Microsoft.SQLServer.Replication.Core.VirtualSubscriberHost Microsoft.SQLServer.Replication.Core.VirtualSubscription
Discovered relationships and their attribuets:
Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualDistributor Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualPublisher Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualSubscriberHost Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsGenericDistributor Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemDatabase Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemEntity Microsoft.SQLServer.Replication.Core.VirtualPublicationHostContainsGenericPublication Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsGenericPublisher Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemDatabase Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemEntity Microsoft.SQLServer.Replication.Core.VirtualPublisherHostsVirtualPublicationHost Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsGenericSubscriber Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsSystemEntity Microsoft.SQLServer.Replication.Core.VirtualSubscriberHostHostsVirtualSubscriber Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsGenericSubscription Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsSystemDatabase

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.Replication.Core.DataSource.DatabaseHealthDiscovery	Microsoft.SQLServer.Core.RunAs.SDK

Source Code:

<Discovery ID="Microsoft.SQLServer.Replication.Core.Discovery.DatabaseHealth" Target="Microsoft.SQLServer.Replication.Core.Seed" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.DatabaseHealth"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisher"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublicationHost"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualDistributor"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriber"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriberHost"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscription"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualPublisher"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualDistributor"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.DatabaseHealthHostsVirtualSubscriberHost"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsGenericPublisher"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisherHostsVirtualPublicationHost"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemEntity"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemDatabase"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualPublicationHostContainsGenericPublication"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemEntity"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemDatabase"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsGenericDistributor"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriberHostHostsVirtualSubscriber"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsSystemEntity"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsGenericSubscription"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsGenericSubscriber"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsSystemDatabase"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.Replication.Core.DataSource.DatabaseHealthDiscovery" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.SDK">

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

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

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

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

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

    <ClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.DatabaseHealth']$</ClassId>

    <VirtualPublisherClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublisher']$</VirtualPublisherClassId>

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

    <VirtualPublisherPublisherRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsGenericPublisher']$</VirtualPublisherPublisherRelationshipId>

    <VirtualPublisherDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemEntity']$</VirtualPublisherDBEngineRelationshipId>

    <VirtualPublisherDatabaseRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublisherContainsSystemDatabase']$</VirtualPublisherDatabaseRelationshipId>

    <VirtualPublicationHostClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublicationHost']$</VirtualPublicationHostClassId>

    <PublicationClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericPublication']$</PublicationClassId>

    <VirtualPublicationHostPublicationRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualPublicationHostContainsGenericPublication']$</VirtualPublicationHostPublicationRelationshipId>

    <VirtualDistributorClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualDistributor']$</VirtualDistributorClassId>

    <VirtualDistributorDatabaseRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemDatabase']$</VirtualDistributorDatabaseRelationshipId>

    <VirtualDistributorDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsSystemEntity']$</VirtualDistributorDBEngineRelationshipId>

    <DistributorClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericDistributor']$</DistributorClassId>

    <VirtualDistributorDistributorRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualDistributorContainsGenericDistributor']$</VirtualDistributorDistributorRelationshipId>

    <VirtualSubscriberHostClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriberHost']$</VirtualSubscriberHostClassId>

    <VirtualSubscriberClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriber']$</VirtualSubscriberClassId>

    <SubscriberClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericSubscriber']$</SubscriberClassId>

    <VirtualSubscriberSubscriberRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsGenericSubscriber']$</VirtualSubscriberSubscriberRelationshipId>

    <VirtualSubscriberDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriberContainsSystemEntity']$</VirtualSubscriberDBEngineRelationshipId>

    <VirtualSubscriptionClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscription']$</VirtualSubscriptionClassId>

    <SubscriptionClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.GenericSubscription']$</SubscriptionClassId>

    <VirtualSubscriptionSubscriptionRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsGenericSubscription']$</VirtualSubscriptionSubscriptionRelationshipId>

    <VirtualSubscriptionDatabaseRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Core.VirtualSubscriptionContainsSystemDatabase']$</VirtualSubscriptionDatabaseRelationshipId>

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>