Home
  •  

MSSQL on Windows: Discover Database Engine Resource Pools

Microsoft.SQLServer.Windows.Discovery.ResourcePool (Discovery)

This rule discovers all resource pools for a given instance of SQL Server DB Engine.

Knowledge Base article:

Summary

This rule discovers all resource pools for a given instance of SQL Server DB Engine.

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Ignore the pools without Memory-Optimized Data

Must be 'true' or 'false'. When this property is set to true then discovery will discover only pools with bound databases. A database can be bound to a pool by using function sys.sp_xtp_bind_db_resource_pool.

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

Element properties:

TargetMicrosoft.SQLServer.Windows.DBEngine
EnabledFalse
Frequency14400
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:

Member Modules:

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

Source Code:

<Discovery ID="Microsoft.SQLServer.Windows.Discovery.ResourcePool" Enabled="false" Target="Microsoft.SQLServer.Windows.DBEngine">

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

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

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

  </DiscoveryTypes>

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

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

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

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

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

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

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

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

    <OnlyInMemoryOLTPPools>true</OnlyInMemoryOLTPPools>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

    <TimeoutSeconds>300</TimeoutSeconds>

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

  </DataSource>

</Discovery>