MSSQL 2014: 内存优化数据范围组发现

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

此发现规则将填充警报和性能数据范围组以包含所有 SQL Server 内存优化数据对象。请注意，仅对支持内存优化数据的 SQL 版本(64 位企业版、开发人员版或评估版)启用此发现规则。

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>