Applies to the following products and features: The SentryOne Monitor product and the on-premises SentryOne Portal feature for SQL Sentry.
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.
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.
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.
Select the (chevron-right icon) to the right of the count to display the individual details about each logged alert:
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.
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.
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.
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.
Select a target from the sidebar to see the details for that specific target.
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.