SQL Sentry Portal target health
What is the Health view?
The Health view is displayed by default at the Global target level when you open SQL Sentry Portal. Use the Inventory menu to view the health of your sites, groups, or individual targets.
As indicated in the name, this view displays the overall health of the monitored targets in your environment. The Health Score graph displays an at a glance health status of your environment. In the Health Score History chart, each bar in the graph represents the overall average health score of your environment daily, helping you to quickly assess the historical health of your environment.
Health for Sites and Groups
The Health view is available for sites and groups in SQL Sentry Portal. Use the Inventory to expand a site and view the groups within it. Select a site or group from the Inventory to navigate to that health view.
Note: The Site and Group icons and labels note which type of overview you are viewing.
The Health Score graph displays the current health of your site or group over the last 24 hours. In the Health Score History chart, each bar in the graph represents the overall average health score of your site or group daily across the last 30 days, allowing you to quickly compare historical scores with your current health score.
Health for individual targets
Navigate to the Health view by doing one of the following:
- Select a target from the Inventory side navigation menu
- Select a target from the Global health view
When you select a Target view in SQL Sentry Portal, the Health view displays by default. The Health view displays the overall health for your selected target.
The Health Score widget displays the current health of your target over the last 24 hours. In the Health Score History chart, each bar in the graph represents the overall average health score of your target daily across the last 30 days, allowing you to quickly compare historical scores with your current health score.
Health Score Calculation
The Health Score incorporates alerts that triggered in the last 24 hours. The Health Score scale is based on the severity, number of occurrences, and the age of the triggered alert. 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.
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 |
Keep track of your server's health
When you are at the Global, Group, or site level, quickly filter between health statuses with the severity toggles. By default, SQL Sentry Portal displays targets with Critical , Unhealthy , and At Risk health ratings.
Health 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.
Any checked status will be included within the filter. For example, if you check Healthy, then Healthy scores will be included with the Critical, Unhealthy, and At Risk default ratings. Uncheck any rating categories that you want to remove from the display.
Note: Unchecking all health statues will display all of the health scores in your environment.
Review vital statistics metrics between the percentage of difference for the day or over the last week. Click the time toggle to toggle between the metrics for the last week (default) or the last 24 hours.
Sort By
Use the Sort By drop-down menu to display the difference between the current score and the last recorded average score for each of the monitored targets in your environment. The Sort By drop-down menu lets you specifically filter by category: Health Score Health Score Delta, CPU,CPU Delta, Transactions/Sec, Transactions/sec Delta, Total Waits, Total Waits Delta, or Regressed Queries. Select the desired category to display the results for all of the monitored targets in your environment.
Note: Selecting to sort by a category unchecks all other Health Score status filters.
Viewing your server's data
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.
Each server card displays server vitals including CPU (%), Transactions/Second, Total Waits, and Regressed Queries over the last 24 hour period or 1 week period.
Regressed queries are queries that meet or exceed the average duration of a completed query baseline (over all available history) by 50 percent within the 24 hour period.
CPU, Trans/Sec, Total Waits, and Regressed Queries values are updated every two minutes.
Each category also contains a comparison from the previous 24 hour period (default) or previous week, highlighting increased categories in red and decreased categories in green. For example, in the image below, the Trans/Sec category has seen a 4 percent decrease when compared to the recorded Transactions/Second for the previous day. This allows you to easily identify changes in vital stat values with consistent activity compared to the previous day values.
View alerts across your system in the Alerts tab
The Alerts tab displays all available alerts recorded and can be filtered to display alerts from the last 24 hours. Alerts recorded within the last 24 hours 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 message, alert type, and statistics. The Alert Details page also provides useful link(s) to more resources regarding the alert.
Additional Information: For more information about the Alerts, see the Alerts topic.