Integritätsermittlung für die Replikationsdatenbank

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

Die Objektermittlung ermittelt die aggregierten Integritätscontainer und -beziehungen für Objekte, die sich auf eine veröffentlichte Datenbank beziehen.

Knowledge Base article:

Zusammenfassung

Die Objektermittlung ermittelt die aggregierten Integritätscontainer und -beziehungen für Objekte, die sich auf eine veröffentlichte Datenbank beziehen.

Überschreibbare Parameter

Name	Beschreibung	Standardwert
Aktiviert	Aktiviert oder deaktiviert den Workflow.	Ja
Intervall (Sekunden)	Das periodische Intervall in Sekunden, in dem der Workflow ausgeführt werden soll.	14400
Timeout (Sekunden)	Timeout (Sekunden)	300
Synchronisierungszeit	Synchronisierungszeit

Element properties:

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

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.Replication.Library.DatabaseHealth Microsoft.SQLServer.Replication.Library.VirtualDistributor Microsoft.SQLServer.Replication.Library.VirtualPublicationHost Microsoft.SQLServer.Replication.Library.VirtualPublisher Microsoft.SQLServer.Replication.Library.VirtualSubscriber Microsoft.SQLServer.Replication.Library.VirtualSubscriberHost Microsoft.SQLServer.Replication.Library.VirtualSubscription
Discovered relationships and their attribuets:
Microsoft.SQLServer.Replication.Library.DatabaseHealthHostsVirtualDistributor Microsoft.SQLServer.Replication.Library.DatabaseHealthHostsVirtualPublisher Microsoft.SQLServer.Replication.Library.DatabaseHealthHostsVirtualSubscriberHost Microsoft.SQLServer.Replication.Library.VirtualDistributorContainsComputerRole Microsoft.SQLServer.Replication.Library.VirtualDistributorContainsGenericDistributor Microsoft.SQLServer.Replication.Library.VirtualDistributorContainsSystemDatabase Microsoft.SQLServer.Replication.Library.VirtualPublicationHostContainsGenericPublication Microsoft.SQLServer.Replication.Library.VirtualPublisherContainsComputerRole Microsoft.SQLServer.Replication.Library.VirtualPublisherContainsGenericPublisher Microsoft.SQLServer.Replication.Library.VirtualPublisherContainsSystemDatabase Microsoft.SQLServer.Replication.Library.VirtualPublisherHostsVirtualPublicationHost Microsoft.SQLServer.Replication.Library.VirtualSubscriberContainsComputerRole Microsoft.SQLServer.Replication.Library.VirtualSubscriberContainsGenericSubscriber Microsoft.SQLServer.Replication.Library.VirtualSubscriberHostHostsVirtualSubscriber Microsoft.SQLServer.Replication.Library.VirtualSubscriptionContainsGenericSubscription Microsoft.SQLServer.Replication.Library.VirtualSubscriptionContainsSystemDatabase

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>