MSSQL 2014: descobrir grupo de arquivos de dados com otimização de memória

Microsoft.SQLServer.2014.Discovery.DBFileGroupFx (Discovery)

Esta regra de descoberta descobre as informações do grupo de arquivos de dados com otimização de memória para cada banco de dados do SQL Server 2014.

Knowledge Base article:

Element properties:

Object Discovery Details:

Member Modules:

Source Code:

<Discovery ID="Microsoft.SQLServer.2014.Discovery.DBFileGroupFx" Enabled="false" Target="Microsoft.SQLServer.2014.DBEngine">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2014.DBFileGroupFx">

      <Property TypeID="Microsoft.SQLServer.2014.DBFileGroupFx" PropertyID="GroupID"/>

      <Property TypeID="Microsoft.SQLServer.2014.FileGroup" PropertyID="GroupName"/>

      <Property TypeID="Microsoft.SQLServer.2014.FileGroup" PropertyID="ReadOnly"/>

      <Property TypeID="Microsoft.SQLServer.2014.FileGroup" PropertyID="TypeDesc"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Microsoft.SQLServer.2014.DBFileGroupDiscovery">

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

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

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

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>