Home
  •  

MSSQL 2014: 探索資料庫引擎資源集區

Microsoft.SQLServer.2014.Discovery.ResourcePool (Discovery)

此探索規則會探索指定的 SQL Server 2014 資料庫引擎執行個體的所有資源集區。

Knowledge Base article:

摘要

此探索規則會探索指定的 SQL Server 2014 資料庫引擎執行個體的所有資源集區。

可覆寫的參數

名稱

描述

預設值

已啟用

啟用或停用該工作流程。

是

間隔 (秒)

執行工作流程的週期性時間間隔 (秒)。

14400

同步處理時間

使用 24 小時制指定的同步處理時間。將會忽略。

14400

逾時 (秒)

指定允許工作流程在關閉且標示為失敗之前執行的時間。

 

Timeout (seconds)

Specifies the time the workflow is allowed to run before being closed and marked as failed.

300

Element properties:

TargetMicrosoft.SQLServer.2014.Database
EnabledTrue
Frequency14400
RemotableFalse

Object Discovery Details:

Discovered Classes and their attribuets:

Member Modules:

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

Source Code:

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

  <Category>Discovery</Category>

  <DiscoveryTypes>

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

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="PoolID"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="Name"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MinCpuPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MaxCpuPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="CapCpuPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MinMemoryPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MaxMemoryPercent"/>

    </DiscoveryClass>

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

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="PoolID"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="Name"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MinCpuPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MaxCpuPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="CapCpuPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MinMemoryPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MaxMemoryPercent"/>

    </DiscoveryClass>

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

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="PoolID"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="Name"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MinCpuPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MaxCpuPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="CapCpuPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MinMemoryPercent"/>

      <Property TypeID="Microsoft.SQLServer.2014.ResourcePool" PropertyID="MaxMemoryPercent"/>

    </DiscoveryClass>

  </DiscoveryTypes>

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

    <IntervalSeconds>14400</IntervalSeconds>

    <SyncTime/>

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

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

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

    <TimeoutSeconds>300</TimeoutSeconds>

    <OnlyInMemoryOLTPPools>true</OnlyInMemoryOLTPPools>

  </DataSource>

</Discovery>