Home
  •  

[Deprecated] Azure SQL DB: DB Internal Network Egress (KB)

Microsoft.SqlServer.Azure.PerformanceRule.DatabaseNetworkInternalEgress (Rule)

This rule collects internal network egress for Microsoft Azure SQL Database in kilobytes. This rule has been deprecated in Azure SQL Database V12 logical server.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.

Knowledge Base article:

Summary

This rule collects number of kilobytes of data sent from this database to other databases in the cloud in the last 60 minutes. This rule has been deprecated in Azure SQL Database V12 logical server.

Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.

Overrideable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

No

Interval (seconds)

The recurring interval of time in seconds in which to run the workflow. Note that interval value should be divisible by 300.

900

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.

600

Element properties:

TargetMicrosoft.SqlServer.Azure.Database
CategoryPerformanceCollection
EnabledFalse
Alert GenerateFalse
RemotableTrue

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SqlServer.Azure.Module.DatabaseNetworkMonitoringDataSource Default
Mapper ConditionDetection Microsoft.SqlServer.Azure.Module.PropertyBagCookdownPerformanceDataMapper Default
WriteToDB WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
WriteToDW WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default

Source Code:

<Rule ID="Microsoft.SqlServer.Azure.PerformanceRule.DatabaseNetworkInternalEgress" Target="Microsoft.SqlServer.Azure.Database" Enabled="false" ConfirmDelivery="false">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SqlServer.Azure.Module.DatabaseNetworkMonitoringDataSource">

      <IntervalSeconds>900</IntervalSeconds>

      <SyncTime/>

      <TimeoutSeconds>600</TimeoutSeconds>

      <ServerName>$Target/Property[Type="Microsoft.SqlServer.Azure.Database"]/ServerName$</ServerName>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="Mapper" TypeID="Microsoft.SqlServer.Azure.Module.PropertyBagCookdownPerformanceDataMapper">

    <ObjectName>SQL Azure Database</ObjectName>

    <CounterName>Internal Network Egress (KB)</CounterName>

    <InstanceName/>

    <ResourceName>$Target/Property[Type="Microsoft.SqlServer.Azure.Database"]/DatabaseName$</ResourceName>

    <MetricName>InternalEgress</MetricName>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>