MSSQL: Descoberta de Integridade do Banco de Dados de Replicação Genérica

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

A descoberta de objeto descobre os contêineres de integridade agregados e relações de objetos a um banco de dados publicado.

Knowledge Base article:

Resumo

A descoberta de objeto descobre os contêineres de integridade agregados e relações de objetos a um banco de dados publicado.

Parâmetros Substituíveis

Nome	Descrição	Valor Padrão
Habilitado	Habilita ou desabilita o fluxo de trabalho.	Sim
Intervalo (segundos)	O intervalo de tempo recorrente em segundos no qual executar o fluxo de trabalho.	14400
Tempo de Sincronização	Tempo de Sincronização
Tempo limite (segundos)	Tempo limite (segundos)	15
Tempo limite (segundos)	Especifica a quantidade de tempo que o fluxo de trabalho tem permissão para executar antes de ser fechado e marcado como com falha.	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>