Solutions > AppInsight Applications > Understanding AppInsight for SQL > Database Availability

Database Availability

This resource graphically shows the various states of database availability in a percentage format.

The content includes:

  • Legend for the availability of the application
  • Availability bar chat depicting the availability in percentage per sample interval (example every hour)
  • Timeline chart with adjustable time range by date



Clicking Edit lets you change the default zoom range, the amount of historical data loaded, and set the sample interval time period, as well as reveal the Advanced section.

Zooming

You can have the chart show a predetermined, hourly time period of data by clicking on any one of the three Zoom buttons; 1h, 12h, or 24h. Alternatively, you can have the chart show a specific time range by dragging the mouse over a small area of the chart.

Once you have a time period selected, the lower chart zooms to the starting and ending values of the selected time period. With the lower chart you can zoom in further by fine tuning the view with the sliders. The main view of the chart displays the selected time period between the two sliders of the lower chart.

Moving the mouse over the main chart reveals a tooltip with more detailed information about the specific time period the mouse is hovering over.