Database State

Microsoft.SqlServer.Azure.View.UserDatabaseState (View)

This state view will display health state and attributes of monitored Microsoft Azure SQL User Databases.

Element properties:

Source Code:

<View ID="Microsoft.SqlServer.Azure.View.UserDatabaseState" TypeID="SC!Microsoft.SystemCenter.StateViewType" Target="Microsoft.SqlServer.Azure.UserDatabase" Visible="true" Accessibility="Public">

  <Category>Operations</Category>

  <Criteria/>

  <Presentation>

    <ColumnInfo Index="0" SortIndex="0" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="true" SortOrder="Descending">

      <Name>State</Name>

      <Id>Microsoft.SqlServer.Azure.UserDatabase</Id>

    </ColumnInfo>

    <ColumnInfo Index="1" SortIndex="-1" Width="22" Grouped="false" Sorted="false" IsSortable="true" Visible="true" SortOrder="Ascending">

      <Name>Maintenance Mode</Name>

      <Id>InMaintenanceMode</Id>

    </ColumnInfo>

    <ColumnInfo Index="2" SortIndex="-1" Width="190" Grouped="false" Sorted="true" IsSortable="true" Visible="true" SortOrder="Ascending">

      <Name>Server Name</Name>

      <Id>Microsoft.SqlServer.Azure.Database/ServerName</Id>

    </ColumnInfo>

    <ColumnInfo Index="3" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="true" SortOrder="Ascending">

      <Name>Name</Name>

      <Id>Name</Id>

    </ColumnInfo>

    <ColumnInfo Index="4" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Path</Name>

      <Id>Path</Id>

    </ColumnInfo>

    <ColumnInfo Index="5" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Display Name</Name>

      <Id>System.Entity/DisplayName</Id>

    </ColumnInfo>

    <ColumnInfo Index="6" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Database Id</Name>

      <Id>Microsoft.SqlServer.Azure.Database/DatabaseId</Id>

    </ColumnInfo>

    <ColumnInfo Index="7" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="false" SortOrder="Ascending">

      <Name>Database Name</Name>

      <Id>Microsoft.SqlServer.Azure.Database/DatabaseName</Id>

    </ColumnInfo>

    <ColumnInfo Index="8" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="true" SortOrder="Ascending">

      <Name>Size Quota (MB)</Name>

      <Id>Microsoft.SqlServer.Azure.Database/MaxSize</Id>

    </ColumnInfo>

    <ColumnInfo Index="9" SortIndex="-1" Width="100" Grouped="false" Sorted="false" IsSortable="true" Visible="true" SortOrder="Ascending">

      <Name>Pricing Tier</Name>

      <Id>Microsoft.SqlServer.Azure.Database/PricingTier</Id>

    </ColumnInfo>

  </Presentation>

</View>