SQL Sentry Portal & SentryOne Monitor Health

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

Health Overview

Overview

The Overview tab is displayed by default. As indicated in the name, this view is showing the overall health, and 10 most recent alerts for all monitored targets in your environment.

SentryOne Monitor Overview displaying a 72/100 Health Score, Alerts by Severity and Tag, and a list of selectable Alerts.

Health Score Calculation

The Health Score (shown above) is calculated by incorporating open alerts and their associated severity. It uses a fixed 5-day window in the calculation, which is why the date selector is disabled for this view. A high health score (with a maximum of 100 possible) is an indicator of good health.

The points per severity level are:

  • Low - 1 point
  • Medium - 3 points
  • High - 6 points
  • Critical - 9 points

Note:  The weight of an open alert diminishes with its age. The score being presented is 100 minus the sum of the weighted value of open alerts. Closed alerts are not factored into the score. Alerts can be closed in the Events Log in the SentryOne configuration client.

Alert Details

Select the (chevron-right icon) to the right of the count to display the individual details about each logged alert on any of the health views:

SentryOne Monitor Alert Details view filtered by End Time.

EHO for Sites and Groups

The Environment Health Overview (EHO) is available for sites and groups in SentryOne Portal. Use the Show Hierarchy switch to toggle the list of targets between a flat list and a list grouped by sites.

SentryOne Monitor Health Overview for the Default Site and Show Hierarchy toggled in the list of targets.Example of the EHO at the site level (using Default Site)

Expand a site to view the groups within it and select a group to view a group EHO.

SentryOne Monitor Health Overview for an Azure SQL DB Group selected from the expanded Default Site.Example of the EHO at the group level (using Azure SQL DB)

Note:  The Site and Group icons and labels note which type of overview you are viewing.

All SQL Servers View

Select All SQL Servers from the sidebar to display the overall health view for all SQL Servers in your monitored environment.

SentryOne Monitor Health View All SQL Servers view organized by Severity

Note:  Uptime is a measure of the percentage of time that SentryOne Monitor is able to connect to the server to collect data.

The All SQL Servers view provides options for viewing overall health through Alerts by Severity, Alerts by Tag, and Wait Time / Session. These views are similar to the target health views described below, but they include the overview information for all monitored SQL Servers.

Target Health View

When selecting a target, the Health view is the default view. This screen displays wedgets for Alerts by Severity, Alerts by Tag, and Wait Time / Session. The default view is Alerts by Severity.

Alerts by Severity

In the example below, the Alerts by Severity wedget is displaying 1 Critical and 316 Medium severity alerts. In the Alerts table, you can see 1 alert with a severity of critical, and 3 rows of medium alerts (78, 237, and 1) totaling 316. This is how the number in the color-coded alert is calculated.

SentryOne Monitor Health tab displaying 1 Critical alert, and 3 Medium alerts corresponding to the Health wedget display.Alerts by Severity example

Note:  Selecting the blue hyperlinked target name on the left provides an option to switch to the Health, Dashboard, or Top SQL, Blocking, or Deadlocks view for that target.

Alerts by Tag

The Alerts by Tag view works by incorporating alerts to calculate the scores and associate them to tags on the alerts (Network, CPU, Memory, Disk, and Other). The score for these views is based on the severity of all open alerts within the selected time period. A high health score (with a maximum of 100 possible) is an indicator of good health.

SentryOne Monitor Health tab displaying Alerts by Tag highlighting CPU and Disk alerts that correspond with the wedget,Alerts by Tag example

Wait Time / Session

Wait Time / Session relies on wait stats data collected by SentryOne. These wait stats are broken down by major resource category (Network, CPU, Memory, Disk, Other). In this view, the health score worsens as waits increase. A low ms/session score is an indicator of good health. 

Each category is calculated independently. The displayed value for a category is calculated as the waits for the category divided by the user sessions. The values for waits and user sessions are based on the most recent values present in the selected time frame. Each value is then rounded and displayed as the category’s value. The overall score is the sum of the five rounded categories.

The Other category is for other important wait types that either affect performance in more than one major category, or can't be directly attributed to any category with absolute certainty, such as backups and parallelism respectively.

SentryOne Monitor Health view organized by Wait Time/ Session and displaying two related targets.Wait Time / Session example

Related Targets

As seen in the image above, there is a list of Related Targets (1 SQL Server and 1 Windows Server in this example). When there are multiple instances on a SQL Server, they will be listed as a related target, as will the Windows Server where the SQL Server is installed.