Log
Overview
Applies to the following products and features: The SentryOne Monitor product and the on-premises SentryOne Portal feature for SQL Sentry.
Note: Only the Log view is available for SentryOne Portal.
SentryOne Monitor delivers a workable set of alerts that have been carefully chosen by experienced Microsoft data platform professionals for their relevance to most database monitoring situations.
From the Alerts page, you can configure alerts to send email notifications to yourself or other members of your organization. See the Details & Emails tab in this article for step-by-step instructions.
Log
Alerts view for SentryOne Monitor
Note: The on-premises SentryOne Portal Alerts view only displays the Log. All alert configurations are still managed via the SentryOne client.
Example of the Alerts view available through SentryOne Portal
Note: The default view on the Alerts page displays the 5 most recent alerts logged across your environment (Start Time ). You can sort the table by any of the available columns.
Note: The following columns are all read-only or hyperlinks.
| Column | Description | ||||
|---|---|---|---|---|---|
| Target | The covered area of the watched target that triggered the alert. Note: If the scope of the target is at the server or instance level (i.e. Q-REGRESSION and not Q-REGRESSION: SQL Server Agent Jobs), then it will be a hyperlink to display Health, Dashboards, or Top SQL for that target). | ||||
| Closed | An event may be opened or closed and this status syncs from the configuration client where it may be set. A closed event may indicate that someone within your organization has responded to or investigated the alert.
| ||||
| Type | The alert type, such as SQL Server, a deadlock (Deadlocks: Deadlock), etc. | ||||
| Configuration | The name of the alert. Select the hyperlink to navigate to the Configuration tab. | ||||
| State | The state of the alert (e.g. active or completed). An active alert has a start time, but no end time, as the situation is still meeting the conditions of the alert. | ||||
| Severity | The severity may be high, medium, or low. Note: The severity is blank unless the alert is sourced from an advisory condition alert category. | ||||
| Start Time | The time the alert started evaluating to true. | ||||
| End Time | The time the alert stopped evaluating to true. | ||||
| Duration | The amount of time that the alert was true. Note: The smallest value displayed is in seconds. If an alert was active for 500ms, it would display a duration of < 1s. | ||||
| View | Select the Details hyperlink to view a popup window containing the details logged for the alert: The available details vary depending on the condition, and may contain information such as the step of a failed SQL Server Agent job and the error behind the failure (as shown in the image above). On an alert such as High CPU, the performance counter value collected at the time of the alert evaluation is included (e.g. Performance Counter: Processor Information: % Processor Time, Total [97.4264] > [90] *TRUE* ). |
Configuration
Configuration
Applies to the following products and features: The SentryOne Monitor product.
The default view on the Configuration page displays the available alerts in SentryOne Monitor. From this tab you can select the Name to view information about the significance of the alert or configure email notifications. Select the Status to access the Evaluation Status details.
Note: The following columns are all read-only or hyperlinks.
| Column | Description | ||||
|---|---|---|---|---|---|
| Name | The descriptive name of the alert, such as Data File Shrink or High CPU. Select the name hyperlink to open the Alert window where you can view additional information about the meaning of the alert, as well as set up email notifications. See the Details & Emails tab in this article for more information. | ||||
| Is Enabled | Displays a switch indicating whether or not the alert is enabled to execute checks for the condition.
| ||||
| Type | The coverage area (e.g. Global, Top Commands, etc.), target type (e.g. SQL Server, Azure SQL Database, Windows Computer, etc.), or SentryOne component (e.g. Monitoring Service) affected by the alert. | ||||
| Tags | These are used to group the alerts by common goals (e.g. Auditing, Performance, CPU, Memory, etc.) | ||||
| Actions | Select the Status hyperlink to display the Evaluation Status table. |
Details & Emails
Alert About & Email Notifications
Applies to the following products and features: The SentryOne Monitor product.
Select the hyperlinked Name from the Configuration table on the Alerts page to view the Alert window:
The alert window displays a Status and Severity at the top:
- Status: Displays On or Off to indicate whether the alert is (High Compiles + High CPU, in this example) enabled to execute checks against the alert's condition. This is the same as Is Enabled on the Configuration tab.
- Severity: Only alerts with a Category of Advisory Conditions may have an associated severity level. The severity levels may be High, Medium, or Low.
About
The About section displays information about the alert's purpose or meaning, and hints or links for how to troubleshoot or investigate (where applicable).
- Show "About" by default: When this box is selected, the About section is expanded on the Alerts window, when it is not selected, the About section is collapsed by default.
Note: The Show "About" by default option is a global setting for all Alert windows.
Email Notifications
You have the option to send alert emails when an alert's condition evaluates to True.
Important: SentryOne will send a maximum of 50 alert emails per day. This maximum is for all emails, across all alerts. It is recommended that you only configure email notifications for critical alerts that require a fast response so that you keep your overall emails to a minimum, and do not miss emails for more important alerts.
Select Send alerts for [Condition Name] to me at [email@address.com] to receive email notifications for the associated alert, at the default email address for your user name. A toast notification pops up to confirm the change. Deselect this option to disable email notifications for the associated alert, for your user name.
Use the Send alerts for [Condition Name] to these email adresses: option to enter additional email addresses that should receive alert emails. Enter an email address, or multiple email addresses (separated by a comma), then select Add. Once you have the email addresses entered, use the Back to Conditions button to save the changes.
Select the X after an additional email address to stop it from receiving alert emails for the associated alert.
Important: Changes to email addresses (adding or deleting) are not saved until you select the Back to Alerts button.
Note: You can send alert emails to yourself, others, or a combination of these emails.
Evaluation Status
Evaluation Status
Applies to the following products and features: The SentryOne Monitor product.
The Evaluation Status table is accessed by selecting a row from the Actions column in the Configuration table.
Note: The following columns are all read-only or hyperlinks.
| Column | Description |
|---|---|
| Object Name | The name of the target associated with the evaluation. Note: The hyperlink provides option to jump to the health, dashboard, or top SQL for the target. |
| Last Result | Displays the outcome of the most recent evaluation against the alert. The result will be True or False. Example: The High CPU alert checks for sustained CPU usage over 90%.
|
| Evaluation Duration | The amount of time it took to evaluation the result of the alert. |
| Last Evaluation Time | The last time the evaluation completed. |
| Last Error | If there was an error during the evaluation attempt, it displays information here. |
| Evaluation Type | Displays whether the evaluation was executed as Scheduled or Manual. Each alert in SentryOne Monitor is set to evaluate at a frequency specific to the alert. Scheduled indicates that the evaluation was performed on schedule by the monitoring service. For example, the High CPU alert is scheduled to evaluate every 30 seconds, while the SQL Server Paged to Disk alert is scheduled to evaluate every 5 minutes. Manual means that a user chose to evaluate the alert ad-hoc through the configuration client. This is an infrequent Evaluation Type in SentryOne Monitor as users rarely need to access the configuration client. |
Available Alerts
Available Alerts
Applies to the following products and features: The SentryOne Monitor product.
The following alerts are available with SentryOne Monitor.
|
|
