The SQL Sentry Portal 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. The Alerts Log displays a list of all of the conditions in your SQL Sentry environment that have evaluated to True.
From the Alerts Log, you can sort and filter current and active alerts across your environment monitored by SQL Sentry. View the most recent 15 alerts by default or dig deeper into previously recorded alerts. With Versions 2022.4 and later, you can assign a user to an active alert directly from the Alerts Log, add/edit notes on selected alerts, and close out alerts.
Note: The default view on the Alerts Log page displays the 15 most recent alerts logged across your environment (Start Time ). You can sort the table by any of the available columns.
The following Alerting information is displayed on the Alerts Log grid:
|Top 5 Servers||The top 5 servers by alert count in real-time, or across the selected timeframe.|
|Top 5 Conditions||The top 5 conditions by alert count in real-time, or across the selected timeframe.|
|Top 5 Tags||The top 5 tags by alert count in real-time, or across the selected timeframe.|
|Close||Select the checkbox to close out the selected alert.|
Select the button to filter by the alert resolution status.
|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, Performance, Top SQL, Blocking, Deadlocks, or TempDB for that target).
|Type||The alert type, such as SQL Server, a deadlock (Deadlocks: Deadlock), etc.|
|Name||The name of the alert.|
|Condition Type||Conditions can fall into the General, Audit, Failsafe, and Advisory categories. For more information about the types of conditions categorized by SQL Sentry, see the General Conditions, Audit Conditions, Failsafe Conditions, and Advisory Conditions articles.|
Select the button to filter by specific condition types.
|Action Type||The action that is set to occur once the monitored condition has been met. Actions are configured in the SQL Sentry client in the Conditions pane. For more information about configuring actions, and the available actions in SQL Sentry, see the Actions article.|
Select the button to filter by specific action types.
|Assigned User||The user or group assigned to the alert. If a user or group has not been assigned, select the drop-down menu and select the user or group you want to assign. You can also search for a user or group with the drop-down search bar.|
|Severity||The severity may be high, medium, or low. For more information about alert severity within SQL Sentry, see the|
Select the button to filter by specific severity levels.
|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.
|Notes||Add, edit, or delete notes for a selected alert. See the Notes section below for more information.|
The details logged for any selected alert are displayed on Alert details screen below the Alerts Log grid.
The alert window displays a Severity at the top. Only alerts with a Category of Advisory Conditions have an associated severity level. The severity levels may be High, Medium, or Low.
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.
On an alert such as High CPU, which looks for CPU greater than 90, 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] >  *TRUE* ).
You can filter the alerts log by the Close, Condition Type, Action Type, or Severity categories; or you can filter by a combination of those categories. Filter the Alerts Log by completing the following steps:
- Select the button for the desired category to open the filter drop-down menu.
- Select the options you would like to filter by, and then select the X icon to close the list of options.
- Select Apply to apply your filter.
- Repeat the steps above for any additional categories.
Note: Select the Clear button at the top of the Alerts Log to clear any filter.
Filtering alerts with the Top 5 charts
Select an option from any of the Top 5 charts to filter the Alerts Log by your selection. For example, in the image below we selected Q-Regression from the Top 5 Servers chart to filter by the Q-Regression server.
Filtering with the Search bar
Use the search bar to further filter your Alerts Log. Type your search parameters into the search bar and select enter to filter the Alerts Log.
Adding, Editing, and Deleting Notes
Starting with Versions 2022.4 and later, you can add, edit, and delete notes for any given alert using the Alerts Log grid.
Select Add/View Notes to open the Note Text column in the Alerts Log grid. The following options are available:
|Add||Select Add to open the Add Note window. Enter the text for your note in the textbox and then select Create to save your note.|
Note: Select Include in Notifications to include your note in the alert notification.
|Include In Notifications||Indicates whether this note is included in alert notifications. A checkmark means the note is included.|
|Select to open the Edit Note window. Enter the text for your note in the textbox and then select Save to save your note.|
|Select to open the Delete Note window. Select Delete to permanently delete the note.|
Note: A prompt displays when you have successfully added, edited, or deleted a note.
|Note Text||A sample of the note text.|
|Username||The username that logged the note.|
|Log Time||The date and time the note was added or edited.|