Provider dimensioni del file di log del database SQL 2016 (ottimizzato)

Microsoft.SQLServer.2016.DBLogFileSizeOptimizedPerfProvider (DataSourceModuleType)

Element properties:

Show References:
- Rules (4)

Type	DataSourceModuleType
Isolation	Any
Accessibility	Internal
RunAs	Microsoft.SQLServer.MonitoringAccount
OutputType	System.Performance.Data

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.2016.DBLogFileSizeRawPerfProvider	Default
OptimizedFilter	ConditionDetection	System.Performance.OptimizedCollectionFilter	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name	Description
IntervalSeconds	int	$Config/IntervalSeconds$	Intervallo (secondi)	Intervallo di tempo ricorrente in secondi in cui eseguire il flusso di lavoro.
SyncTime	string	$Config/SyncTime$	Ora di sincronizzazione	Ora di sincronizzazione specificata usando il formato a 24 ore. Può essere omessa.
TimeoutSeconds	int	$Config/TimeoutSeconds$	Timeout (secondi)	Specifica il tempo di esecuzione consentito per il flusso di lavoro prima che venga chiuso e contrassegnato come non riuscito.
AzureMaxFileSizeMB	int	$Config/AzureMaxFileSizeMB$	Dimensioni massime del file in Azure (MB)	Dimensioni massime del file di dati archiviato nell'archiviazione BLOB di Azure. Il flusso di lavoro considera questo valore come la capacità di archiviazione massima per ogni file.

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2016.DBLogFileSizeOptimizedPerfProvider" Accessibility="Internal" RunAs="GPMP!Microsoft.SQLServer.MonitoringAccount">

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="IntervalSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SyncTime" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ConnectionString" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ServerName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SqlInstanceName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ObjectName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="CounterName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="InstanceName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="DatabaseName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="DBFileId" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Value" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Tolerance" type="xsd:double"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" minOccurs="0" maxOccurs="1" name="ToleranceType">

      <xsd:simpleType>

        <xsd:restriction base="xsd:string">

          <xsd:enumeration value="Absolute"/>

          <xsd:enumeration value="Percentage"/>

        </xsd:restriction>

      </xsd:simpleType>

    </xsd:element>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="MaximumSampleSeparation" type="xsd:unsignedInt"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="TimeoutSeconds" type="xsd:int"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="AzureMaxFileSizeMB" type="xsd:int"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="IntervalSeconds" ParameterType="int" Selector="$Config/IntervalSeconds$"/>

    <OverrideableParameter ID="SyncTime" ParameterType="string" Selector="$Config/SyncTime$"/>

    <OverrideableParameter ID="TimeoutSeconds" ParameterType="int" Selector="$Config/TimeoutSeconds$"/>

    <OverrideableParameter ID="AzureMaxFileSizeMB" ParameterType="int" Selector="$Config/AzureMaxFileSizeMB$"/>

  </OverrideableParameters>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

        <DataSource ID="DS" TypeID="Microsoft.SQLServer.2016.DBLogFileSizeRawPerfProvider">

          <IntervalSeconds>$Config/IntervalSeconds$</IntervalSeconds>

          <SyncTime>$Config/SyncTime$</SyncTime>

          <ConnectionString>$Config/ConnectionString$</ConnectionString>

          <ServerName>$Config/ServerName$</ServerName>

          <SqlInstanceName>$Config/SqlInstanceName$</SqlInstanceName>

          <ObjectName>$Config/ObjectName$</ObjectName>

          <CounterName>$Config/CounterName$</CounterName>

          <InstanceName>$Config/InstanceName$</InstanceName>

          <DatabaseName>$Config/DatabaseName$</DatabaseName>

          <DBFileId>$Config/DBFileId$</DBFileId>

          <Value>$Config/Value$</Value>

          <TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>

          <AzureMaxFileSizeMB>$Config/AzureMaxFileSizeMB$</AzureMaxFileSizeMB>

        </DataSource>

        <ConditionDetection ID="OptimizedFilter" TypeID="SystemPerf!System.Performance.OptimizedCollectionFilter">

          <Tolerance>$Config/Tolerance$</Tolerance>

          <ToleranceType>$Config/ToleranceType$</ToleranceType>

          <MaximumSampleSeparation>$Config/MaximumSampleSeparation$</MaximumSampleSeparation>

          <SamplingPeriodInSeconds>$Config/IntervalSeconds$</SamplingPeriodInSeconds>

        </ConditionDetection>

      </MemberModules>

      <Composition>

        <Node ID="OptimizedFilter">

          <Node ID="DS"/>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <OutputType>SystemPerf!System.Performance.Data</OutputType>

</DataSourceModuleType>