MSSQL per Windows: Provider dimensioni file di database (ottimizzato)

Microsoft.SQLServer.Windows.DataSource.DBFileSizeOptimizedPerfProvider (DataSourceModuleType)

Provider dimensioni file di database SQL (ottimizzato)

Element properties:

Show References:
- Rules (8)

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

Member Modules:

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

Overrideable Parameters:

ID	ParameterType	Selector
SqlExecTimeoutSeconds	int	$Config/SqlExecTimeoutSeconds$
SqlTimeoutSeconds	int	$Config/SqlTimeoutSeconds$	Timeout per la connessione di database (secondi)	Il flusso di lavoro avrà esito negativo e registrerà un evento se non riesce ad accedere al database durante il periodo specificato.
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.
IntervalSeconds	int	$Config/IntervalSeconds$	Intervallo (secondi)	Intervallo di tempo ricorrente in secondi in cui eseguire il flusso di lavoro.
SyncTime	string	$Config/SyncTime$	Tempo di sincronizzazione	Ora di sincronizzazione specificata usando il formato a 24 ore. Può essere omessa.
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.Windows.DataSource.DBFileSizeOptimizedPerfProvider" Accessibility="Internal" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.Monitoring">

  <Configuration>

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

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="NetbiosComputerName" 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="FileName" type="xsd:string"/>

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

    <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="PerfInstanceName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ValuePropertyName" 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="ConnectionString" type="xsd:string"/>

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

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

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

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

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

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

    <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"/>

  </Configuration>

  <OverrideableParameters>

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

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

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

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

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

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

  </OverrideableParameters>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

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

          <MachineName>$Config/MachineName$</MachineName>

          <NetbiosComputerName>$Config/NetbiosComputerName$</NetbiosComputerName>

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

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

          <FileName>$Config/FileName$</FileName>

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

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

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

          <PerfInstanceName>$Config/PerfInstanceName$</PerfInstanceName>

          <ValuePropertyName>$Config/ValuePropertyName$</ValuePropertyName>

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

          <InstanceVersion>$Config/InstanceVersion$</InstanceVersion>

          <InstanceEdition>$Config/InstanceEdition$</InstanceEdition>

          <MonitoringType>$Config/MonitoringType$</MonitoringType>

          <SqlExecTimeoutSeconds>$Config/SqlExecTimeoutSeconds$</SqlExecTimeoutSeconds>

          <SqlTimeoutSeconds>$Config/SqlTimeoutSeconds$</SqlTimeoutSeconds>

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

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

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

        </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>