This rule collects the percentage of write resource utilization of the service tier limit by Microsoft Azure SQL Database.
Collects the percentage of write resource utilization of the service tier limit by Microsoft Azure SQL Database.
Target | Microsoft.SqlServer.Azure.Database |
Category | PerformanceCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.SqlServer.Azure.Module.DatabaseResourceStatsMonitoringDataSource | Default |
Mapper | ConditionDetection | Microsoft.SqlServer.Azure.Module.PropertyBagPerformanceDataMapper | Default |
WriteToDB | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
WriteToDW | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.SqlServer.Azure.PerformanceRule.DatabaseLogWritePercent" Target="Microsoft.SqlServer.Azure.Database" Enabled="true" ConfirmDelivery="false">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SqlServer.Azure.Module.DatabaseResourceStatsMonitoringDataSource">
<IntervalSeconds>900</IntervalSeconds>
<SyncTime/>
<TimeoutSeconds>300</TimeoutSeconds>
<ServerName>$Target/Property[Type="Microsoft.SqlServer.Azure.Database"]/ServerName$</ServerName>
<DatabaseName>$Target/Property[Type="Microsoft.SqlServer.Azure.Database"]/DatabaseName$</DatabaseName>
</DataSource>
</DataSources>
<ConditionDetection ID="Mapper" TypeID="Microsoft.SqlServer.Azure.Module.PropertyBagPerformanceDataMapper">
<PropertyName>LogWritePercent</PropertyName>
<ObjectName>SqlAzure$$$Target/Property[Type="Microsoft.SqlServer.Azure.Database"]/ServerName$ : Database</ObjectName>
<CounterName>Log Write (%)</CounterName>
<InstanceName>$Target/Property[Type="Microsoft.SqlServer.Azure.Database"]/DatabaseName$</InstanceName>
</ConditionDetection>
<WriteActions>
<WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>