This rule collects average memory amount used by one Windows Azure SQL Database session in megabytes.
Collects average amount of virtual memory in megabytes consumed by all sessions for this 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.DatabaseSessionsMonitoringDataSource | 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.DatabaseSessionsAverageMemoryMb" Target="Microsoft.SqlServer.Azure.Database" Enabled="true" ConfirmDelivery="false">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.SqlServer.Azure.Module.DatabaseSessionsMonitoringDataSource">
<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>AvgMemoryMB</PropertyName>
<ObjectName>SqlAzure$$$Target/Property[Type="Microsoft.SqlServer.Azure.Database"]/ServerName$ : Database</ObjectName>
<CounterName>Sessions Average Memory Consumption (MB)</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>