Monitor Health

The Health view is the default view when opening SentryOne Monitor. This screen displays wedgets for Alerts by Severity and Alerts by Tag on the default view for All Servers.

All Servers View

The All Servers view 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 Health View All Servers

In the example below, the Alerts by Severity wedget is displaying 2 critical and 186 high severity alerts. In the Alerts table (now sorted by Severity ), you can see 2 alerts with a severity of critical, and 3 rows of high alerts (183, 2, and 1) totaling 186. This is how the number in the color-coded alert is calculated.

SentryOne Monitor Health View All Servers Alerts by Severity

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

Details

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

SentryOne Monitor Health View Details

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

Alerts by Severity

The Alerts by Severity view (shown above) works by incorporating alerts and their associated severity to calculate the scores. A high health score (with a maximum of 100 possible) is an indicator of good health. The score for these views is based on the severity of all open alerts within the selected time period. The severity points are as follows:

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

A table of alerts is below the targets.

Note:  Select the (chevron-up icon) on the right to collapse the Targets grid.

SentryOne Monitor Health View All SQL Servers collapse wedgets

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 View All SQL Servers Alerts By Tag

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 All SQL Servers Wait Time/ Session

Target View

Select a target from the sidebar to see the details for that specific target.

SentryOne Monitor Health View by Target

Related Targets

As seen in the image above, there is a list of Related Targets (3 SQL Servers 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.