MSSQL 2014 : Détection du groupe d'étendues OLTP en mémoire

Microsoft.SQLServer.2014.Discovery.InMemoryOLTPScopeGroup (Discovery)

Cette règle de détection peuple le groupe d'étendues de données de performance et des alertes afin de contenir tous les objets OLTP en mémoire SQL Server.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.2014.Discovery.InMemoryOLTPScopeGroup" Target="Microsoft.SQLServer.2014.InMemoryOLTPScopeGroup" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2014.InMemoryOLTPScopeGroup"/>

  </DiscoveryTypes>

  <DataSource ID="DiscoveryDataSource" TypeID="SC!Microsoft.SystemCenter.GroupPopulator">

    <RuleId>$MPElement$</RuleId>

    <GroupInstanceId>$Target/Id$</GroupInstanceId>

    <MembershipRules>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Microsoft.SQLServer.2014.DBFileGroupFx"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.2014.Relationships.InMemoryOLTPScopeGroupContainsDBFileGroupFx"]$</RelationshipClass>

      </MembershipRule>

      <MembershipRule>

        <MonitoringClass>$MPElement[Name="Microsoft.SQLServer.2014.UserResourcePool"]$</MonitoringClass>

        <RelationshipClass>$MPElement[Name="Microsoft.SQLServer.2014.Relationships.InMemoryOLTPScopeGroupContainsResourcePool"]$</RelationshipClass>

      </MembershipRule>

    </MembershipRules>

  </DataSource>

</Discovery>