Monitor Alerts



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


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.

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)
SentryOne Monitor Event Switch OpenSentryOne Monitor Event Switch Closed
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:
SentryOne Monitor Alert Details view
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* ).


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.

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)
SentryOne Monitor Is Enabled switch DisabledSentryOne Monitor Is Enabled Switch Enabled
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

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 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.


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 [] 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. 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.

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

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.

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.


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.
Available Alerts

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
  • High Avg Wait Time per User Session
  • High CPU
  • High CPU for non-SQL Server process
  • 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: Offline
  • SQL Server: Online
  • Suspect Pages - Active Corrupt Pages
  • Windows: Offline
  • Windows: Online