Chat now with support
Chat with Support

Foglight for SQL Azure 5.5.8.6 - User Guide

Introducing Foglight for SQL Azure Adding and Configuring Agents Reviewing SQL Azure Activity Reviewing Database Usage Reviewing the Database Properties Monitoring Estimated Costs Viewing User Metrics Using the Global Administration Options Reviewing Foglight for SQL Azure Alarms Glossary

Configuring Alarm-triggered Email Notifications

The Notification Settings pane allows configuring the various variables of alarm-triggered email notifications. Such notifications are sent only if all of the following conditions are met:
•
The alarm meets the predefined minimal severity level for notification
•
The alarm is enabled for invoking email notifications.
 
* 
IMPORTANT: As detailed below, alarms can be enabled individually, per group or as a whole, by selecting All Alarms.
•
The alarm is fired
Use this pane to define the conditions mentioned above, as well as general mailing preferences and message prefixes.
The contents of the Notification Settings pane changes according to the selection made in the Alarms list, as follows:
•
Clicking All Alarms displays all of the currently configured alarms, indicating the alarm title and its status. This view allows handling only the entire set of displayed alarms, using the Enable all or Disable all buttons.
 
* 
IMPORTANT: In the All Alarms view, the Notification Settings pane displays also the Server Settings tab, which allows configuring the email settings for the Foglight Management Server’s default mail server. These settings apply to all of the agents. For details, see Configuring Foglight Mail Server on page 70.
•
Clicking the title of a specific group (for example, Baseline or Locks) displays all of the alarms currently configured for this group, indicating the alarm title and its status. This view allows handling only the entire set of displayed alarms, using the Enable all or Disable all buttons.
•
Selecting a specific alarm allows viewing and editing all of the settings defined for the selected alarm.
In a single alarm view, the Email Notification Settings pane comprises the following sections:
•
Alarm Notification Status—indicates whether the alarm is enabled for sending email notifications, and allows enabling or disabling this property
•
Warning, Critical and Fatal panes—each of these panes allows editing the notification settings by clicking Edit.
To configure the notification settings:
1
In the Alarms list, click All Alarms.
2
Click the Email Notification Settings > Notification Settings pane.
3
Click Define email settings.
Figure 12. The Email Notification Settings dialog box appears.
This dialog box allows carrying out the following tasks:
•
Setting the severity levels for which notifications will be sent—using the field Messages will be enabled for severities, which allows defining the threshold severity level (such as the Warning, Critical, or Fatal state) that, when reached or exceeded, will trigger the sending of an email notification.
•
Applying identical settings for all enabled severities—by selecting the option Configure settings for all enabled severities and clicking the All severities link.
•
Applying different settings to each of the enabled severities—by selecting the option Configure severity-specific settings and clicking the requested severity’s link.
4
Configure the requested settings.
5
Click Set.
Figure 13. The Message Setting dialog box appears.
6
Enter the recipient email address in the To field (mandatory), and the addresses of additional recipients in the CC field (optional). If needed, change the content of the Subject field and type text in the Body prefix box.
7
Click Set to save the customized settings or Cancel to reject them.
Upon clicking Set, the Edit Notification Settings dialog box appears.
8
Click Set to save the customized settings or Cancel to reject them.
9
Proceed to configure Foglight email settings, by using the Mail Server Settings section.

Configuring Foglight Mail Server

The Server Settings pane under the E-mail Notification Settings panel allows defining the global mail server variables (connection details) to be used for sending email notifications.
 
* 
NOTE: The Server Settings pane is displayed only when selecting All Alarms under the Alarms list.
To configure the Mail Server settings:
1
Click the Server Settings tab.
2
In the Mail Server Setting section, click Edit.
Figure 14. The Edit Mail Server Settings dialog box appears.
3
Type values for the following parameters:
•
Server Hostname—the name of the mail server
•
Username—the username that is used for sending out email notifications
•
Password—the password of the sender (namely: the username)
•
Mail From—the sender’s email address
•
Protocol—the mail protocol used for sending Email; either SMTP or SMTPS
•
Port—mail server port
•
Use SSL—defines whether to use secure connection
4
Click Set.
5
To ensure that the email addresses were appropriately configured, click Verify Settings.
Figure 15. The Verify Mail Server Settings dialog box appears.
6
Select the requested email address.
7
Click Verify.
If the verification process failed, carry out the requested modifications in the mail server settings and repeat this process.
8
Click Save changes to save the customized settings.
Upon successful completion of the verification process, Foglight is configured for sending out email notifications.

Configuring Usage Costs

The Cost Configuration administration screen is used for setting the prices, in US dollars, for bandwidth and storage usage. As these prices form the basis for the estimated cost calculations in Foglight for SQL Azure, entering data in this screen is mandatory for the cartridge’s proper functioning.
 
* 
IMPORTANT: The settings made in the Cost Configuration screen are applied at instance level, regardless of whether the selected agent is an instance or a database. For example: if the only agent currently selected is a single database agent, out of 20 databases that run on a specific instance, the settings made in this screen will modify the instance’s configuration, thereby applying to all 20 databases.
 
* 
IMPORTANT: The prices set via this screen are fixed, and do not depend on usage level.
To set the requested storage and bandwidth usage prices:
1
Select the check boxes near the requested agents.
2
Click Edit.
Figure 16. The Set Cost Configuration dialog box appears.
3
Edit one or more of the following settings:
•
Storage price—the price, per GB, of space usage
•
Outgoing price—the price, per GB, of bandwidth usage for outgoing data (data sent from the database)
•
Incoming price—the price, per GB, of bandwidth usage for incoming data (data arriving to the database)
4
Click Set.

Setting the User Account

The User Account administration screen is used for setting the Windows Live ID and data center, which are used for accessing and using SQL Azure services.
 
* 
IMPORTANT: The settings made in the User Account screen are applied at instance level, regardless of whether the selected agent is an instance or a database. For example: if the only agent currently selected is a single database agent, out of 20 databases that run on a specific instance, the settings made in this screen will modify the instance’s configuration, thereby applying to all 20 databases.
To set the requested storage and bandwidth usage prices:
1
Select the check boxes near the requested agents.
2
Click Edit.
Figure 17. The Set User Account dialog box appears.
3
Use the Windows Live ID section to enter the email address used for accessing SQL Azure, as well as any other Windows Live ID-enabled web sites.
4
Use the Data Center section to enter the name of the data center to which the instance reports, in either of the following methods:
•
Entering a user-defined name—by filling-in the field under the button Enter a data center name.
After adding the requested name, it can be added to the Data Centers table by selecting the check box below this field. However, even without selecting this check box, the new name is available for all SQL Azure agents monitored by the selected Foglight Agent Manager.
•
Selecting a predefined Microsoft data center from the Data Center table.
5
Click Set.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating