Foglight for SQL Azure 5.5.8.6

The Managing SQL Azure Database Systems User Guide provides configuration instructions, conceptual information and instructions on how to use the Foglight for SQL Azure cartridge.

This guide is intended for SQL Azure database administrators.

Foglight for SQL Azure Summary View

The Foglight for SQL Azure Summary provides a quick and intuitive representation of SQL Azure database architecture and activity. Using the Summary allows efficient, real-time diagnosis and resolution of SQL Azure operation and performance issues.

The summary comprises several panes, each of them relating to areas of the SQL Azure's architecture through performance metrics. These panes are connected by a series of graphical flows that represent the data flows between the areas of SQL Azure's architecture. The various graphical elements and metrics change color as their values move through a range of thresholds, and the data flows' values are updated in real time to illustrate the rate at which data is moving through the system.

Reviewing the Databases Dashboard


	NOTE: The following section describes the various components of the Databases dashboard. To learn how to customize this dashboard’s display and focus on a requested instance, see Selecting the Database to be Monitored on page 8.

The Foglight for SQL Azure Summary is launched via the Databases dashboard.

To access the Databases dashboard:

Ensure that the navigation panel on the left is open.

To open the navigation panel, click the right-facing arrow on the left.

On the navigation panel, click Homes > Databases.

The Databases dashboard provides an at-a-glance view of the monitored environment, with all of the currently monitored database types.

Figure 1. Databases dashboard

The Databases dashboard comprises the sections listed below.

•

Advanced operations section—includes the following buttons:

•

Discover more databases—allows adding instances, and all databases running on them, to be monitored. For details, see Adding and Configuring Agents on page 19.

•

Administer Agents—after selecting one or more instances of the same database type, allows setting options for collecting, storing, and displaying data for the selected instances. For details, see Using the Global Administration Options on page 56.

•

Database cartridge type tiles—each tile represents a database type (SQL Server, SQL Azure, Oracle, Sybase, DB2, or All) and displays the number of instances for each database type, along with a breakdown according to the instance health state severity (Normal, Warning, Critical, Fatal).

•

Status section—includes the following components:

•

Status summary—a color-coded bar, which provides a visual representation of the summarized health condition of all databases listed in the Database Group table.

The status summary bar provides a graphic representation of the monitored environment’s current state, broken down to the number of instances and their current health state: Fatal, Critical, Warning, Normal or Unknown.

•

Database-specific health summary—when the database group All is selected, this section displays all of the currently monitored instances for each database type, divided by their health state (for example: four SQL Azure instances, three of which have the health state Warning and one is indicated with the health state Fatal). When a user-defined database group is selected, this section displays data only about the agents included within the selected group.

The Status Indicators section can be used for filtering the Databases Group table to display only instances that meet a criterion set in this section. For details, see Filtering the Display by Severity on page 9.

•

Currently selected database group table—a list of all monitored databases within the database group that is currently selected in the Databases section. For more information, see Currently Selected Group on page 8.

Currently Selected Group

This Databases table displays the group that is currently selected from the available database groups under the Databases section of the navigation pane.

The Databases table contains the columns listed below.


	NOTE: The CPU, Memory, Disk Busy and SC columns, which are irrelevant for SQL Azure, are not displayed if only the SQL Azure tile is selected. When selecting the tile All, these columns appear with the indication N/A on the SQL Azure rows.

Table 1. Currently Selected Group Table

The SQL Azure instance’s highest severity alarm, which determines the instance’s health state.

Name

The name of the SQL Azure instance.

Version

The version number of the SQL Azure instance.

Up Since

The date and time when the SQL Azure instance was last restarted.