Chat now with support
Chat with Support

Foglight for Azure SQL Database (Cartridge) 7.2.1 - User Guide

Installing and Configuring Agents Using Foglight for Azure SQL Database Administering Foglight for Azure SQL Database Reporting Reference
Overview of Collections SQL Performance Investigator Metrics
Active Connections Active Time Active Time per Execution Active Time Rate Always On Average CPU Percent Average DTU Percent Average Memory Usage Percent Average SQL Response Time Average XTP Storage Percent Average Data IO Percent Average Log Write Percent Backup Recovery Blocked Sessions Connections CPU Limit CLR Wait CLR Wait per Execution CLR Wait Rate CPU Time CPU Time per Execution CPU Time Rate CPU Wait CPU Wait per Execution CPU Wait Rate Cursor Synchronization Database Replication Deferred Task Worker Distributed Transaction DTU Limit Elapsed Time Executions External Procedure Full Text Search Governor Wait Governor Wait per Execution Governor Wait Rate Granted Memory Hosted Component Inactive User Connections I/O Bulk Load I/O Completion I/O Data Page I/O Wait I/O Wait per Execution I/O Wait Rate Idle Time Internal Cache Latch Latch Buffer Latch Savepoint Latch Wait Latch Wait per Execution Latch Wait Rate Lead Blockers Lock Bulk Update Lock Exclusive Lock Intent Lock Schema Lock Shared Lock Update Lock Wait Lock Wait Rate Lock Wait per Execution Log Buffer Log Other Log Synchronization Log Wait Log Wait per Execution Log Wait Rate Log Write Logical Reads Logical Reads per Execution Max Degree of parallelism Max DTU Percent Max Session Percent Max Workers Percent Memory Wait Memory Wait per Execution Memory Wait Rate Network HTTP Network I/O Network IPC Network Mirror Network Wait Network Wait per Execution Network Wait Rate OLEDB Provider Full Text Other Miscellaneous Other Wait Other Wait per Execution Other Wait Rate Parallelism Wait Percent of Total Plan Recompilations Physical Reads Physical reads per Execution Preemptive Wait Preemptive wait per Execution Preemptive Wait Rate Remote Provider Wait Remote Provider wait per Execution Remote Provider Wait Rate Row count Service Broker Synchronous Task Wait Time Percent Writes Writes per Execution XTP Log write Wait XTP Miscellaneous Wait XTP Procedure Wait XTP Transaction Wait XTP Wait XTP Wait per Execution XTP Wait Rate
Glossary

Reviewing the Administration Settings

Use the Databases Administration dashboard to set options for collecting, storing, and displaying data, which apply to all of the currently selected agents. Click a category of settings on the left (for example: Connection Details) to open a view containing related settings on the right.

The metrics defined on the Databases Administration dashboard apply to all of the agents that were selected before opening the Administration dashboard. As a result, the same unit of measure and aggregation value for display are enforced for all currently selected agents.

To view the full list of selected agents, click Selected Agents button at the upper right corner of the screen. To change the list of agents to which the metrics apply, exit the Databases Administration dashboard, select the required agents, and re-open the dashboard.

If the settings vary between the selected agents (for example: one agent uses the measurement unit kilobyte, while another uses megabyte), the fields that contain non-identical values are displayed as empty and marked with an Inconsistent Values () icon.

Changes made to settings should be saved before selecting another category of settings.

To save changes made in an Administration dashboard view:
1
In the Database Administration dashboard, select a category of settings from the left-hand panel.
2
Make changes to settings as necessary.
3
Click Save changes at the bottom of the view.
If you attempt to exit the view without saving changes, a Warning dialog box prompts you to confirm your action.

Customizing Alarms for Foglight for Azure SQL Database Rules

Customizing Alarms for Foglight for Azure SQL Database Rules
* 
NOTE: Foglight introduces Alarm Templates, which provide a simplified method for customizing alarm rules and applying them to agents. As part of this change, the Sensitivity Level feature has been deprecated.

Many Foglight for Azure SQL Database multiple-severity rules trigger alarms. To improve your monitoring experience, you can use alarm templates to customize when alarms are triggered and whether they are reported. You can also set up email notifications.

This section covers the following topics:

�
Introducing the Alarms View
�
Modifying Alarm Templates
�
Configuring Email Notifications
�
Cloning Agent Settings
�
Reviewing Rule Definitions

Introducing the Alarms View

The Alarms view enables you to modify global settings and agent-specific settings for alarms.

To open the Alarms view:
1
Open the Administration dashboard as described in Opening the Databases Administration Dashboard .
2
Click Alarms.
The list of agents that you selected on the Databases dashboard is shown in the upper right corner of the view.
3
From the Alarms view, you can complete the following tasks:
•
Modifying Alarm Templates
•
Configuring Email Notifications
•
Cloning Agent Settings

Modifying Alarm Templates

Foglight uses alarm templates to gather alarm rules into a domain-specific template that is easily modified and applied to targets. You can customize how the alarms generated by the default Foglight for Azure SQL Database rules are y assigning alarm templates via the Alarm Template Settings tab. You can apply an existing template, create a new template using an existing template as reference, or create a template based on an agent. All changes to alarm templates apply to the selected agents.

Refer to Viewing, Creating, and Managing Alarm Templates in the Foglight User Guide for more information.

* 
IMPORTANT: Avoid editing Foglight for Azure SQL Database rules in the Administration > Rules & Notifications > Rule Management dashboard. Default rules may be modified during regular software updates and your edits will be lost. Always use the Alarm Templates dashboard.

The Alarms list controls the contents displayed to the right and the tasks that are available.

�
All Alarms � Displays all rules with configured alarms and indicates whether alarms are enabled. In this view, you can enable or disable alarms for all the rules at once. You can also set email notifications and define mail server settings. When viewing all alarms, the Alarm Template Settings tab is displayed, enabling configuration of alarm templates
�
Category of rules � Displays a set of related rules with configured alarms. In this view, you can set email notifications for the category of rules.
�
Rule name � Displays the Email Notification Status for the selected rule. If the rule has multiple severity levels, displays the notification configured for each severity level. In this view, you can enable or disable email notifications for the alarm and edit alarm messages.

You can complete the following tasks:

�
Modifying alarm threshold values
�
Modifying alarm threshold values
�
Configuring Email Notifications

Your changes are saved separately and applied over the default rules. This protects you from software upgrades that may change the underlying default rules.

Assign an Alarm Template to selected agents

You can override the alarm rules for the selected agents by assigning an alarm template. You can use the template to enable or disable alarms for all rules or an individual rule, or to change the threshold values of an alarm rule.

To see descriptions of the rules, follow the steps described in Reviewing Rule Definitions .

To assign an existing alarm template:
1
In the Alarms view, click the Alarm Template Settings tab.
2
Select Assign a template to selected agent(s),
3
Do one of the following:
�
Select an alarm template from the drop-down.
�
Click Save and Navigate.
OR
�
Select Create a new template from the drop-down. This will allow you to create a new template based of an existing template.
�
In the Clone from field, select the template to copy.
�
Enter a name for the new template.
�
Click Save and Navigate.
4
The template will be displayed in the Alarm Template dashboard. Refer to Viewing, Creating, and Managing Alarm Templates in the Foglight User Guide for more information on editing alarm templates.

 

Modifying alarm threshold values

You can and should modify the thresholds associated with alarms to better suit your environment. If you find that alarms are firing for conditions that you consider to be acceptable, you can change the threshold values that trigger the alarm. You can also enable or disable severity levels to better suit your environment.

When a rule has severity levels, a Threshold section appears in the Alarm Settings tab showing the severity levels and bounds by agent. Many rules, such as Baseline rules, do not have severity levels and thresholds.

When editing thresholds, ensure that the new values make sense in context with the other threshold values. For most metrics, threshold values are set so that Warning < Critical < Fatal.

To change severity levels and thresholds:
* 
IMPORTANT: The procedure below is a summary. Refer to Viewing, Creating, and Managing Alarm Templates in the Foglight User Guide for more information on editing alarm templates for more information on working with alarm templates.
1
In the Navigation panel, click Alarm Templates.
2
If you have previously configured an alarm template, select that template.
Otherwise, click the Factory Template to view the default rules. Duplicate the factory template to make an editable copy, selecting the appropriate domains.
3
Click the appropriate domain tab (SQL Server, SQL Analysis Services, etc).
4
Scroll or search to find the alarm rule you want to edit. Click the rule to select it.
5
Edit the rules using the procedure described in Viewing, Creating, and Managing Alarm Templates in the Foglight User Guide
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating