SQL 인스턴스 페이지 수명 예상 매핑된 데이터 원본

Microsoft.SQLServer.2014.DBEngine.PageLifeExpectancy.DataSourceMapped (DataSourceModuleType)

SQL 인스턴스(SQL Database 엔진)의 페이지 수명 예상에 대한 데이터 원본은 System.Performance.Data를 반환합니다.

Element properties:

TypeDataSourceModuleType
IsolationAny
AccessibilityInternal
RunAsDefault
OutputTypeSystem.Performance.Data

Member Modules:

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

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
IntervalSecondsint$Config/IntervalSeconds$간격(초)워크플로를 실행하는 반복 시간 간격(초)입니다.

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2014.DBEngine.PageLifeExpectancy.DataSourceMapped" Accessibility="Internal">
<Configuration>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="IntervalSeconds" type="xsd:integer"/>
</Configuration>
<OverrideableParameters>
<OverrideableParameter ID="IntervalSeconds" Selector="$Config/IntervalSeconds$" ParameterType="int"/>
</OverrideableParameters>
<ModuleImplementation>
<Composite>
<MemberModules>
<DataSource ID="DS" TypeID="Microsoft.SQLServer.2014.DBEngine.PageLifeExpectancy.DataSource">
<IntervalSeconds>$Config/IntervalSeconds$</IntervalSeconds>
<NetworkComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</NetworkComputerName>
<SQLPerformanceCounterObject>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/PerformanceCounterObject$</SQLPerformanceCounterObject>
<SQLServiceName>$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/ServiceName$</SQLServiceName>
</DataSource>
</MemberModules>
<Composition>
<Node ID="DS"/>
</Composition>
</Composite>
</ModuleImplementation>
<OutputType>SystemPerf!System.Performance.Data</OutputType>
</DataSourceModuleType>