Monitor Alerts

Overview

Applies to the following products and features: The SentryOne Monitor product and the on-premises SentryOne Portal feature for SQL Sentry.

Note:  Only the Log view is available for SentryOne Portal.

SentryOne Monitor delivers a workable set of alerts that have been carefully chosen by experienced Microsoft data platform professionals for their relevance to most database monitoring situations.

From the Alerts page, you can configure alerts to send email notifications to yourself or other members of your organization. See the Details & Emails section in this article for step-by-step instructions.

Log

SentryOne Monitor Alerts LogAlerts view for SentryOne Monitor

Note:  The on-premises SentryOne Portal Alerts view only displays the Log. All alert configurations are still managed via the SentryOne client.

Example of the Alerts view available through SentryOne Portal

Note:  The default view on the Alerts page displays the 5 most recent alerts logged across your environment (Start Time ). You can sort the table by any of the available columns.

Note:  The following columns are all read-only or hyperlinks.

ColumnDescription
TargetThe covered area of the watched target that triggered the alert.

Note:  If the scope of the target is at the server or instance level (i.e. Q-REGRESSION and not Q-REGRESSION: SQL Server Agent Jobs), then it will be a hyperlink to display Health, Dashboards, or Top SQL for that target).
TypeThe alert type, such as SQL Server, a deadlock (Deadlocks: Deadlock), etc.
NameThe name of the alert.
StateThe state of the alert (e.g. active or completed). An active alert has a start time, but no end time, as the situation is still meeting the conditions of the alert.
SeverityThe severity may be high, medium, or low.

Note:  The severity is blank unless the alert is sourced from an advisory condition alert category.
Start TimeThe time the alert started evaluating to true.
End TimeThe time the alert stopped evaluating to true.
DurationThe amount of time that the alert was true.

Note:  The smallest value displayed is in seconds. If an alert was active for 500ms, it would display a duration of < 1s.
ViewSelect the Details hyperlink to view a popup window containing the details logged for the alert:
SentryOne Monitor Alert Details viewThe available details vary depending on the condition, and may contain information such as the step of a failed SQL Server Agent job and the error behind the failure .

On an alert such as High CPU, which looks for CPU greater than 90, the performance counter value collected at the time of the alert evaluation is included (e.g. Performance Counter: Processor Information: % Processor Time, Total [97.4264] > [90] *TRUE* ).

Configuration

Applies to the following products and features: The SentryOne Monitor product.

The default view on the Configuration page displays the available alerts in SentryOne Monitor. From this tab you can select the Name to view information about the significance of the alert or configure email notifications. Select the Status to access the Evaluation Status details.

SentryOne Monitor Alerts Configuration

Note:  The following columns are all read-only or hyperlinks.

ColumnDescription
NameThe descriptive name of the alert, such as Data File Shrink or High CPU.

Select the name hyperlink to open the Alert window where you can view additional information about the meaning of the alert, as well as set up email notifications. See the Details & Emails section in this article for more information.
TypeThe coverage area (e.g. Global, Top Commands, etc.), target type (e.g. SQL Server, Azure SQL Database, Windows Computer, etc.), or SentryOne component (e.g. Monitoring Service) affected by the alert.
TagsThese are used to group the alerts by common goals (e.g. Auditing, Performance, CPU, Memory, etc.)
EmailDisplays On if any email alerts are configured or Off if there are none.
ActionsSelect the Status  hyperlink to display the Evaluation Status table.

Alert Details & Email Notifications

Applies to the following products and features: The SentryOne Monitor product.

Select the hyperlinked Name from the Configuration table on the Alerts page to view the Alert window:

SentryOne Monitor Alert window

The alert window displays a  Severity at the top. Only alerts with a Category of Advisory Conditions have an associated severity level. The severity levels may be High, Medium, or Low.

About

The About section displays information about the alert's purpose or meaning, and hints or links for how to troubleshoot or investigate (where applicable).

  • Show "About" by default: When this box is selected, the About section is expanded on the Alerts window, when it is not selected, the About section is collapsed by default.

Note:  The Show "About" by default option is a global setting for all Alert windows.

Email Notifications

You have the option to send alert emails when an alert's condition evaluates to True.

Important:  SentryOne will send a maximum of 50 alert emails per day. This maximum is for all emails, across all alerts. It is recommended that you only configure email notifications for critical alerts that require a fast response so that you keep your overall emails to a minimum, and do not miss emails for more important alerts.

Select Send alerts for [Condition Name] to me at [email@address.com] to receive email notifications for the associated alert, at the default email address for your user name. A toast notification pops up to confirm the change. Deselect this option to disable email notifications for the associated alert, for your user name.

SentryOne Monitor Send Alerts for condition

Use the Send alerts for [Condition Name] to these email adresses: option to enter additional email addresses that should receive alert emails. 

  1. Enter an email address, or multiple email addresses (separated by a comma).
  2. Select Add
  3. Once you have the email addresses entered, use the Back to Conditions button to save the changes.

SentryOne Monitor Alerts for condition save email address

Select the X after an additional email address to stop it from receiving alert emails for the associated alert.

Important:  Changes to email addresses (adding or deleting) are not saved until you select the Back to Alerts button.

Note:  You can send alert emails to yourself, others, or a combination of these emails.

Evaluation Status

Applies to the following products and features: The SentryOne Monitor product.

The Evaluation Status table is accessed by selecting a row from the Actions column in the Configuration table.

SentryOne Monitor Alerts Configuration Evaluation Status

Note:  The following columns are all read-only or hyperlinks.

ColumnDescription
Object NameThe name of the target associated with the evaluation.

Note:  The hyperlink provides option to jump to other views for the target (e.g. health or dashboard).
Last ResultDisplays the outcome of the most recent evaluation against the alert. The result will be True or False.

Example:

The High CPU alert checks for sustained CPU usage over 90%.
  • True means that the last time this alert was evaluated that the monitored target's CPU was over 90% for at least a minute.
  • False indicates that it did not sustain a value over 90% for at least a minute.
DurationThe amount of time it took to evaluate the result of the alert.
Last Evaluation TimeThe last time the evaluation completed.
Last ErrorIf there was an error during the evaluation attempt, it displays information here.
Evaluation TypeDisplays whether the evaluation was executed as Scheduled or Manual. Each alert in SentryOne Monitor is set to evaluate at a frequency specific to the alert.

Scheduled indicates that the evaluation was performed on schedule by the monitoring service. For example, the High CPU alert is scheduled to evaluate every 30 seconds, while the SQL Server Paged to Disk alert is scheduled to evaluate every 5 minutes.

Manual means that a user chose to evaluate the alert ad-hoc through the configuration client. This is an infrequent Evaluation Type in SentryOne Monitor as users rarely need to access the configuration client.

Available Alerts

Applies to the following products and features: The SentryOne Monitor product.

The following alerts are available with SentryOne Monitor.

  • % Free Space - Data/Log File(s)
  • % Free Space - Disk
  • Amazon RDS for SQL Server: Offline
  • Amazon RDS for SQL Server: Online
  • Azure SQL Database: Offline
  • Azure SQL Database: Online
  • High Avg Wait Time per User Session
  • High CPU
  • High CPU for non-SQL Server process
  • High Pending Disk IO Count
  • SQL Availability Group Failover
  • SQL File Auto-growth Exceeds Free Space
  • SQL Server Agent Job: Failure
  • SQL Server Memory Exhaustion
  • SQL Server Process Paged to Disk
  • SQL Server Process Physical Memory Low
  • SQL Server Process Virtual Memory Low
  • SQL Server: Blocking SQL
  • SQL Server: Deadlock
  • SQL Server: Offline
  • SQL Server: Online
  • Suspect Pages - Active Corrupt Pages
  • Windows: Offline
  • Windows: Online