Documentation forSQL Sentry

SQL Sentry Portal Health

Health Overview

Important:  Starting with Version 2023.3, the Health Overview has been upgraded to an enhanced view, allowing you to easily compare the health scores in your environment.

The Health Overview is displayed by default when you open SQL Sentry Portal. As indicated in the name, this view displays the overall health of the monitored targets in your environment. The Overall Health Score graph displays the current health of your environment over the last 24 hours. Best indicates the highest recorded health score historically, Worst indicates the lowest recorded health score historically, and Total Targets displays the total number of monitored targets within the selection. Each bar in the graph represents the overall health score of your environment across the last 30 days, allowing you to quickly compare baselines with your current health score. 

SQL Sentry Portal 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 24-hour window in the calculation. 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 Alerts Log, or with the Events Log in the SQL Sentry configuration client.

Health scores are color coded, making them easy to identify and compare in the chart. Hover over a bar in the chart to display a tooltip of the score for that day. 

Health scores are color coded as follows:

Color  Score range Health status
Green 90 - 100 Healthy
Light green 80 - 89 Healthy
Yellow 60 - 79 At Risk
Light Orange 50 - 59 At Risk
Orange 30 - 49 Unhealthy
Red 0 - 29 Critical

Environment Score sheet

Quickly filter between health statuses with the Environment Score sheet. The Environment Score sheet displays Critical and Unhealthy scores across the monitored targets in your environment by default. Any checked status will be included within the filter. For example, if you check Healthy, then Healthy scores will be included with the Critical and Unhealthy default scores. Uncheck any scores that you want to remove from the display. Scores are sorted in descending order with lower scores within a selected health status category displayed before higher scores within that category. Any time you select a health score status, the Alerts Log will refresh with alerts corresponding to your selection.

Note:  Unchecking all health statues will display all of the health scores in your environment. 

Delta

Select Delta to display the difference between the current score and the last recorded average health score for each of the monitored targets in your environment.

Note:  Selecting Delta unchecks all other Health Score status categories. 

Each server within your environment is displayed as a card with the health score, target image, target name link, target type, and version number. Click the Target name link to open the Health Overview for that target.

Alerts Log

The Alerts Log displays all of the alerts recorded within the last 24 hours on the Health Overview. All of the recorded alerts contribute directly to the Overall Health score chart. 

Click an alert to open the Alert Details window for your selection. Alert Details displays more detailed information about the alert type, message, and statistics.

SQL Sentry Portal Alert Details view filtered by End Time.

Additional Information: For more information about the Alerts Log, see the Alerts Log topic. 

Jump to other views directly from the Alerts Log. Find the alert where you want to see more details. Select the target link and then select the tab you want to jump to (Health, Performance, Storage, Top SQL, Blocking, Deadlocks, or TempDB) to open that tab for your target.

Health Overview for Sites and Groups

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

SQL Sentry Portal Health Overview for the Default Site and Show Hierarchy toggled in the list of targets.

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

SQL Sentry Portal Health Overview for an Azure SQL DB Group selected from the expanded Default Site.

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

The Overall Health Score graph displays the current health of your Site or Group over the last 24 hours. Best indicates the highest recorded health score historically, and Worst indicates the lowest recorded health score historically for the selected Site or Group. Each bar in the graph represents the overall health score of your Site or Group across the last 30 days, allowing you to quickly compare baselines with your current health score.  

Health tab for individual targets

Navigate to the Health tab by doing one of the following:

  • Select a target from the targets side navigation menu
  • Select a target card from the Environment Score sheet
  • Or select a target >health from the Alerts log 

When you select a Target view in SQL Sentry Portal, the Health tab displays by default. The Health tab displays the overall health about your selected target. At the top of the page are details specific to your target, including Host name, Host operating system, Host Last Boot Up, Host Core Count, Host Memory, and Instance Name. 

The Overall Health Score graph displays the current health of your target over the last 24 hours. Best indicates the highest recorded health score historically, and Worst indicates the lowest recorded health score historically for the selected target. Each bar in the graph represents the overall health score of your target across the last 30 days, allowing you to quickly compare baselines with your current health score.   

Alerts Log

The Alerts Log displays all of the alerts recorded within the last 24 hours for your target. All of the recorded alerts contribute directly to the Overall Health score chart for your target. 

Additional Information: For more information about the Alerts Log, see the Alerts Log topic.