Découverte de l'intégrité de la base de données de réplication

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

La détection d’objets découvre les conteneurs et relations d’intégrité d’agrégat pour des objets associés à une base de données publiée.

Knowledge Base article:

Résumé

La détection d’objets découvre les conteneurs et relations d’intégrité d’agrégat pour des objets associés à une base de données publiée.

Paramètres remplaçables

Nom

Description

Valeur par défaut

Activé

Active ou désactive le flux de travail

Oui

Intervalle (secondes)

Intervalle de temps récurrent en secondes, pendant lequel le workflow est exécuté.

14 400

Délai d'attente (secondes)

Délai d'attente (secondes)

300

Heure de synchronisation

Heure de synchronisation

 

Element properties:

TargetMicrosoft.SQLServer.Replication.Library.Seed
EnabledTrue
Frequency14400
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:
Discovered relationships and their attribuets:

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.Replication.Library.DataSource.DatabaseHealthDiscovery Default

Source Code:

<Discovery ID="Microsoft.SQLServer.Replication.Library.Discovery.DatabaseHealth" Target="Microsoft.SQLServer.Replication.Library.Seed" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Library.DatabaseHealth"/>
<DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Library.VirtualPublisher"/>
<DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Library.VirtualPublicationHost"/>
<DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Library.VirtualDistributor"/>
<DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Library.VirtualSubscriber"/>
<DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Library.VirtualSubscriberHost"/>
<DiscoveryClass TypeID="Microsoft.SQLServer.Replication.Library.VirtualSubscription"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.DatabaseHealthHostsVirtualPublisher"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.DatabaseHealthHostsVirtualDistributor"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.DatabaseHealthHostsVirtualSubscriberHost"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualPublisherContainsGenericPublisher"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualPublisherHostsVirtualPublicationHost"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualPublisherContainsComputerRole"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualPublisherContainsSystemDatabase"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualPublicationHostContainsGenericPublication"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualDistributorContainsComputerRole"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualDistributorContainsSystemDatabase"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualDistributorContainsGenericDistributor"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualSubscriberHostHostsVirtualSubscriber"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualSubscriberContainsComputerRole"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualSubscriptionContainsGenericSubscription"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualSubscriberContainsGenericSubscriber"/>
<DiscoveryRelationship TypeID="Microsoft.SQLServer.Replication.Library.VirtualSubscriptionContainsSystemDatabase"/>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.Replication.Library.DataSource.DatabaseHealthDiscovery">
<IntervalSeconds>14400</IntervalSeconds>
<SyncTime/>
<SqlTimeout>300</SqlTimeout>
<PrincipalName>$Target/Property[Type='Microsoft.SQLServer.Replication.Library.Seed']/PrincipalName$</PrincipalName>
<InstanceName>$Target/Property[Type='Microsoft.SQLServer.Replication.Library.Seed']/InstanceName$</InstanceName>
<ConnectionString>$Target/Property[Type='Microsoft.SQLServer.Replication.Library.Seed']/ConnectionString$</ConnectionString>
<ClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.DatabaseHealth']$</ClassId>
<VirtualPublisherClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualPublisher']$</VirtualPublisherClassId>
<PublisherClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.GenericPublisher']$</PublisherClassId>
<VirtualPublisherPublisherRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualPublisherContainsGenericPublisher']$</VirtualPublisherPublisherRelationshipId>
<VirtualPublisherDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualPublisherContainsComputerRole']$</VirtualPublisherDBEngineRelationshipId>
<VirtualPublisherDatabaseRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualPublisherContainsSystemDatabase']$</VirtualPublisherDatabaseRelationshipId>
<VirtualPublicationHostClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualPublicationHost']$</VirtualPublicationHostClassId>
<PublicationClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.GenericPublication']$</PublicationClassId>
<VirtualPublicationHostPublicationRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualPublicationHostContainsGenericPublication']$</VirtualPublicationHostPublicationRelationshipId>
<VirtualDistributorClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualDistributor']$</VirtualDistributorClassId>
<VirtualDistributorDatabaseRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualDistributorContainsSystemDatabase']$</VirtualDistributorDatabaseRelationshipId>
<VirtualDistributorDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualDistributorContainsComputerRole']$</VirtualDistributorDBEngineRelationshipId>
<DistributorClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.GenericDistributor']$</DistributorClassId>
<VirtualDistributorDistributorRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualDistributorContainsGenericDistributor']$</VirtualDistributorDistributorRelationshipId>
<VirtualSubscriberHostClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualSubscriberHost']$</VirtualSubscriberHostClassId>
<VirtualSubscriberClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualSubscriber']$</VirtualSubscriberClassId>
<SubscriberClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.GenericSubscriber']$</SubscriberClassId>
<VirtualSubscriberSubscriberRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualSubscriberContainsGenericSubscriber']$</VirtualSubscriberSubscriberRelationshipId>
<VirtualSubscriberDBEngineRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualSubscriberContainsComputerRole']$</VirtualSubscriberDBEngineRelationshipId>
<VirtualSubscriptionClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualSubscription']$</VirtualSubscriptionClassId>
<SubscriptionClassId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.GenericSubscription']$</SubscriptionClassId>
<VirtualSubscriptionSubscriptionRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualSubscriptionContainsGenericSubscription']$</VirtualSubscriptionSubscriptionRelationshipId>
<VirtualSubscriptionDatabaseRelationshipId>$MPElement[Name='Microsoft.SQLServer.Replication.Library.VirtualSubscriptionContainsSystemDatabase']$</VirtualSubscriptionDatabaseRelationshipId>
</DataSource>
</Discovery>