Foglight for SQL Azure 5.5.8.6

The Customizer button—found on the upper right corner of most tables and allows inserting additional fields to grids and creating a custom filter. The filter is created by clicking Customizer and specifying the criteria that the various values should meet in order to be displayed in the table (having a specific name, exceeding a certain size, and so on). For detailed instructions and examples, see Foglight User Guide > Working with Dashboards > Working with Tables.

•

Agent settings—opens the relevant screen in the Global Administration view, where available (for example: clicking this button from within the Databases > Locks panel opens the Locks global administration screen).


	NOTE: Global administration settings cannot be applied to databases of different types.

•

Refresh now—clicking this button retrieves the most recent data sample.

Viewing the Foglight for SQL Azure Summary

The following image displays the main elements of the Foglight for SQL Azure Summary window. The table that follows the image identifies each element, and provides a link to display more information, corresponding to the logical data flow within Foglight for SQL Azure Database Summary.

Figure 9. Main Elements of the Foglight for SQL Azure Summary Window

Table 2.
Part ID	Part Name	Explained in
A	Instance identification	Identifying the Instance on page 15
B	Alarms	Monitoring Alarms on page 16
C	Cost Estimation	Reviewing the Estimated Costs on page 16
D	Data flow within the cloud	Tracking the Instance Data Flow on page 17
E	Database activity and storage utilization	Monitoring the Database Activity and Storage on page 17
F	Data flow between the customer’s site and the database	Tracking the Instance Data Flow on page 17
G	Frequently Asked Questions	Reviewing frequently requested statistics on page 18

The main groups (panes) of gathered icons and gauges, which represent the main activity areas in the SQL connection process, are as follows:

•

Instance identification—used for identifying the instance, its type, and operation time. See Identifying the Instance on page 15.

•

Components representing instance data flow—the primary indicators for the costs of data flow provided by the Foglight for SQL Azure Instance home page are the flows representing the external and internal data transfer to and from the database that resides on the SQL Azure cloud. See Tracking the Instance Data Flow on page 17.

•

Database activity and storage utilization pane—displays the main indicators of database activity and workload, as well as the space utilization. See Monitoring the Database Activity and Storage on page 17.

•

Alarms pane—displays summarized alerts about metrics or workloads, defined in the Foglight for SQL Azure Instance Homepage, which have exceeded their pre-configured threshold. If Performance Analysis Agent is installed, this pane displays also alarms regarding this agent’s operation and status. See Monitoring Alarms on page 16.

Identifying the Instance

The Instance identification indicators allow identifying the currently monitored instance, its type and its operation period.

Figure 10. Instance identification indicators

These indicators are as follows:

•

Instance name—identifies the currently monitored instance.

•

Specified time range—indicates the period of time for which data is being displayed.

•

Instance pane—contains the following indicators:

•

DB Type—an icon identifying whether the monitored database’s type is SQL Server, SQL Azure, Sybase, DB2 or Oracle.

•

Version—identifies the database version number, along with the most recently installed service packs.

•

Up Since—identifies the date and time when the instance was last started.

•

Data center—the name of the data center to which the instance reports. This name can be either user-defined or selected from Microsoft’s list.

•

Windows Live ID—the sign-in credentials (email and password) used for entering all Windows Live services.


	IMPORTANT: Both data center and Windows Live ID are configured via the User Account global administration screen. This configuration is carried out at the instance level and applies to all databases within the instance. For more information, see Setting the User Account on page 71.

•

Database edition—the database’s edition type; either Web or Business.

Monitoring Alarms

The Alarms table displays an alarm count, which shows the total number of alarms that were active (not cleared) during the specified time range.

The alarms are divided into the following types:

•

Advisories—provides information about how to enhance the database’s performance.

•

Changes—provides change tracking information.

•

Agent—provides information about changes in the agent status.

•

Thresholds—displays alarms about metrics or workloads, displayed in the Foglight for SQL Azure Instance Homepage, which have been exceeded.

When metrics or workload resources behave normally, without any deviations, the alarm count is displayed as 0. When a configured baseline or threshold has been exceeded, alarms are displayed in colors that represent levels of severity, ranging from yellow to red.

Table 3. Alarms and Alarm Descriptions
Indicator	Description
The following indicators apply to all of the alarm types, including Thresholds.
Yellow (Warning)	The metric (or workload resource) has exceeded the configured threshold or deviated from the baseline.
Orange (Critical)	The metric (or workload resource) has significantly exceeded a threshold or deviated extremely from the baseline.
Red (Fatal)	SQL Azure is not responding, thereby triggering a fatal alarm.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Foglight for SQL Azure 5.5.8.6 - User Guide

Components Shared by all Foglight for SQL Azure Screens

Viewing the Foglight for SQL Azure Summary

Identifying the Instance

Monitoring Alarms