MSSQL on Windows: Database Replicas Discovery

Microsoft.SQLServer.Windows.Discovery.DatabaseReplica (Discovery)

Discovery of database replica Always On objects.

Knowledge Base article:

Summary

This is discovery for Microsoft SQL Server Always On Database Replicas objects on Windows.

Overridable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes
Interval (seconds)	The recurring interval of time in seconds in which to run the workflow.	14400
Synchronization Time	The synchronization time specified by using a 24-hour format. May be omitted.
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	300
Timeout for query execution (seconds)	The workflow will fail and register an event, if the query execution takes longer than the specified period.	60
Timeout for database connection (seconds)	The workflow will fail and register an event, if it cannot access the database during the specified period.	15

Element properties:

Target	Microsoft.SQLServer.Windows.AvailabilityReplica
Enabled	True
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.Core.AvailabilityDatabase Microsoft.SQLServer.Windows.AvailabilityDatabaseHealth Microsoft.SQLServer.Windows.DatabaseReplica
Discovered relationships and their attribuets:
Microsoft.SQLServer.Windows.AvailabilityDatabaseContainsDatabaseReplica Microsoft.SQLServer.Windows.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.Windows.DataSource.DatabaseReplicaDiscovery	Default

Source Code:

<Discovery ID="Microsoft.SQLServer.Windows.Discovery.DatabaseReplica" Target="Microsoft.SQLServer.Windows.AvailabilityReplica" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityDatabase"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Windows.DatabaseReplica"/>

    <DiscoveryClass TypeID="Microsoft.SQLServer.Windows.AvailabilityDatabaseHealth"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Windows.AvailabilityDatabaseReferencesAvailabilityDatabaseHealth"/>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.Windows.AvailabilityDatabaseContainsDatabaseReplica"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.Windows.DataSource.DatabaseReplicaDiscovery">

    <MachineName>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/MachineName$</MachineName>

    <NetbiosComputerName>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/NetbiosComputerName$</NetbiosComputerName>

    <InstanceName>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/InstanceName$</InstanceName>

    <ConnectionString>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/ConnectionString$</ConnectionString>

    <InstanceVersion>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Version$</InstanceVersion>

    <InstanceEdition>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Edition$</InstanceEdition>

    <MonitoringType>$Target/Host/Property[Type="Microsoft.SQLServer.Windows.DBEngine"]/MonitoringType$</MonitoringType>

    <AvailabilityReplicaId>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.AvailabilityReplica"]/UniqueId$</AvailabilityReplicaId>

    <SqlExecTimeoutSeconds>60</SqlExecTimeoutSeconds>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

    <TimeoutSeconds>300</TimeoutSeconds>

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

  </DataSource>

</Discovery>