Home
  •  

ミラー化データベース監視サーバーの検出

Microsoft.SQLServer.2008.Mirroring.WitnessDiscovery (Discovery)

このオブジェクト検出は、SQL Server 2008 データベース エンジンの特定のインスタンスに対して実行されているすべてのミラー化データベース監視サーバーを検出します。既定では、すべてのミラー化データベースの監視サーバーが検出され、監視されます。You can override the discovery to exclude one or more databases from being discovered using the Exclude List.This list takes a comma-separated list of database names or the * character to exclude all databases.

Knowledge Base article:

概要

This object discovery discovers all mirrored databases witnesses running for a given instance of SQL Server 2008 DB Engine.By default witnesses for all mirrored databases are discovered and monitored.You can override the discovery to exclude one or more databases from being discovered using the Exclude List.This list takes a comma-separated list of database names or the * character to exclude all databases.

構成

Exclude List: A comma-separated list of database instances that should be excluded from discovery.You can use the wildcard * to exclude all instances.

Element properties:

TargetMicrosoft.SQLServer.2008.DBEngine
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.2008.Mirroring.WitnessDiscoveryProvider Default

Source Code:

<Discovery ID="Microsoft.SQLServer.2008.Mirroring.WitnessDiscovery" Enabled="true" Target="SQL2008Core!Microsoft.SQLServer.2008.DBEngine">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2008.Mirroring.Witness">

      <Property TypeID="Microsoft.SQLServer.2008.Mirroring.Witness" PropertyID="MirroringGUID"/>

      <Property TypeID="Microsoft.SQLServer.2008.Mirroring.Witness" PropertyID="DatabaseName"/>

      <Property TypeID="Microsoft.SQLServer.2008.Mirroring.Witness" PropertyID="Principal"/>

      <Property TypeID="Microsoft.SQLServer.2008.Mirroring.Witness" PropertyID="Mirror"/>

      <Property TypeID="Microsoft.SQLServer.2008.Mirroring.Witness" PropertyID="Level"/>

    </DiscoveryClass>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2008.Mirroring.Group">

      <Property TypeID="Microsoft.SQLServer.2008.Mirroring.Group" PropertyID="MirroringGUID"/>

    </DiscoveryClass>

    <DiscoveryRelationship TypeID="Microsoft.SQLServer.2008.Mirroring.GroupContainsWitness"/>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.2008.Mirroring.WitnessDiscoveryProvider">

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

    <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</ComputerName>

    <SQLConnectionString>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$</SQLConnectionString>

    <SQLInstanceName>$Target/Property[Type="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</SQLInstanceName>

    <ExcludeList/>

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>