This rule discovers all resource pools for a given instance of SQL Server DB Engine.
This rule discovers all resource pools for a given instance of SQL Server DB Engine.
Name | Description | Default Value |
Ignore pools w/o Memory-Optimized Data | Must be 'true' or 'false'. When this property is set to true then discovery will disover only pools with bound databases. A database can be bound to a pool by using function sys.sp_xtp_bind_db_resource_pool. | Yes |
Enabled | Enables or disables the workflow. | 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 |
Target | Microsoft.SQLServer.Linux.DBEngine |
Enabled | True |
Frequency | 14400 |
Remotable | False |
Discovered Classes and their attribuets: |
---|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SQLServer.Linux.DataSource.ResourcePool | Default |
<Discovery ID="Microsoft.SQLServer.Linux.Discovery.ResourcePool" Enabled="true" Target="Microsoft.SQLServer.Linux.DBEngine">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.Linux.InternalPool"/>
<DiscoveryClass TypeID="Microsoft.SQLServer.Linux.DefaultPool"/>
<DiscoveryClass TypeID="Microsoft.SQLServer.Linux.UserDefinedPool"/>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.Linux.DataSource.ResourcePool">
<MachineName>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/MachineName$</MachineName>
<InstanceName>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/InstanceName$</InstanceName>
<ConnectionString>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/ConnectionString$</ConnectionString>
<OnlyInMemoryOLTPPools>true</OnlyInMemoryOLTPPools>
<SqlTimeoutSeconds>15</SqlTimeoutSeconds>
<TimeoutSeconds>300</TimeoutSeconds>
<IntervalSeconds>14400</IntervalSeconds>
<SyncTime/>
</DataSource>
</Discovery>