Monitor Alerts

Log

Overview

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 tab in this article for step-by-step instructions.

Log

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).
ClosedAn event may be opened or closed and this status syncs from the configuration client where it may be set. A closed event may indicate that someone within your organization has responded to or investigated the alert.
Open (switch to the left, gray)Closed (switch to the right, blue)
TypeThe alert type, such as SQL Server, a deadlock (Deadlocks: Deadlock), etc.
ConfigurationThe name of the alert. Select the hyperlink to navigate to the Configuration tab.
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:

The 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 (as shown in the image above).

On an alert such as High CPU, 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

Configuration

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.

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 tab in this article for more information.
Is EnabledDisplays a switch indicating whether or not the alert is enabled to execute checks for the condition.
Disabled (switch to the left, gray)Enabled (switch to the right, blue)
Note:  Alerts can only be enabled or disabled through the configuration client.
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.)
ActionsSelect the Status  hyperlink to display the Evaluation Status table.
Details & Emails

Alert About & Email Notifications

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

The alert window displays a Status and Severity at the top:

  • Status: Displays On or Off to indicate whether the alert is (High Compiles + High CPU, in this example) enabled to execute checks against the alert's condition. This is the same as Is Enabled on the Configuration tab.
  • Severity: Only alerts with a Category of Advisory Conditions may 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.

Use the Send alerts for [Condition Name] to these email adresses: option to enter additional email addresses that should receive alert emails. Enter an email address, or multiple email addresses (separated by a comma), then select Add. Once you have the email addresses entered, use the Back to Conditions button to save the changes.

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

Evaluation Status 

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

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 the health, dashboard, or top SQL for the target.
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.
Evaluation DurationThe amount of time it took to evaluation 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.