SQL Monitor - 2.3
Using the Alert Inbox - SQL Monitor
The Alert Inbox is an email-style inbox for all the alerts that SQL Monitor has raised. Like an email inbox, you can browse through the list, open a particular alert, mark it as read, or select multiple alerts at a time.
- The Alert Inbox updates automatically to check for new alerts every 30 seconds. You do not need to manually Refresh your browser.
- By default all the alerts are pre-configured with sensible default values.
Seeing more alerts
When you first install SQL Monitor, the Alert Inbox shows a maximum of ten alerts per page.
- To view the next ten alerts, click Older.
- To view the last page of alerts, click Oldest.
- To increase the number of alerts shown, use the Rows to display option below the inbox:
Viewing alerts for a particular object
When you first click the Alerts tab, SQL Monitor always shows every uncleared alert across all your servers. Under Monitored servers, click on a group, host machine, SQL Server instance, or database. The Alert Inbox page title reflects the currently selected object:
Note: If you arrive at the Alert Inbox by clicking on a link from an overview page, the relevant object is pre-selected in the Monitored servers list. Clicking on Uncleared alerts in a database overview page, for example, will automatically select that database, and show only alerts related to it.
To change the list of alerts displayed, continue to drill down in the Monitored servers list. Alerts are shown for the currently selected level and all levels below. If you select a host machine, for example, you will see:
- alerts raised for the machine itself (such as disk space or memory alerts)
- alerts raised for all instances running on it (such as job failed or error log entries)
- alerts raised for all databases on those instances (such as fragmented indexes or backup overdue alerts)
The number in brackets after an object in the Monitored servers list always shows the number of unread alerts, regardless of the current filters applied. As you drill down in the hierarchy, the number of unread alerts at each level is displayed:
Note: The list of alerts is also filtered by whatever is set in the Filter drop-down.
How alerts are sorted in the inbox
Alerts are sorted by the time they were raised, or for continuous alerts, whenever they changed level or were updated to Ended.
Note: The displayed time may differ from the time used to sort the list. In the above example, the displayed alert time shows 2:11 rather than 2:04, as this is when the alert reached its highest level.
An alert's timestamp is not updated when:
- An alert changes to Ended
- An alert is cleared
- An alert downgrades to a lower level
- An alert escalates to a level that it has already previous reached
Actions you can apply to alerts
Do any of the following:
Open an alert, in order to view its details on a separate page
Click anywhere in the row for the alert.
Click Open from the Actions list .
Mark an alert as read
(only available for alerts that are currently unread)
Click Mark as read from the Actions list .
Select the alert using its check box:
then click the Read button:
This is useful when selecting multiple alerts to mark as read.
Open the alert: alert is automatically marked as read.
Clear the alert: alert is automatically marked as read.
Mark an alert as unread
(only available for alerts that are currently read)
Click Mark as unread from the Actions list .
Select the alert using its check box then click the Unread button.
This is useful when selecting multiple alerts to mark as unread.
Clear an alert
(Cleared alerts are hidden from the inbox by default)
Click Clear in the alert row:
Click Clear from the Actions list .
Select the alert using its check box then click the Cleared button.
This is useful when clearing multiple alerts.
Add a comment
Open the alert and select the Comments tab, then use the Add comment button.
Click Add comment from the Actions list .
Select the alert using its check box then click the Comment button. You can add a comment to multiple selected alerts.
Comments are displayed in the Alert Inbox. Only the most recent comment for each alert is available. To display a comment, hold the mouse pointer over the Comments icon .
Select one or more alerts
Select the check box next to each alert.
Configure an alert
Click Configure from the Actions list This takes you to the relevant alert settings page for the selected alert type and object.
Under Actions on the left side, click the Configure alerts link to go to the Alert settings main page, where you can adjust the settings for any alert at any level. See Customizing alerts.
Selecting alerts is a useful way to apply actions to multiple alerts at once, rather than having to perform the action for each alert in turn.
Turn on the check box next to each alert you want to select. Use Shift + click to select a block of alerts.
Selected alerts are highlighted in the inbox by row color.
Applying actions to selected alerts
Use the command bar above the Alert Inbox to apply actions to all the currently selected alerts:
- If you select Add Comment, the same comment will be added to all the selected alerts.
- Clearing or reading a selection of alerts may remove them from the Alert Inbox, depending on the current filter settings.
Inline commands and actions from the Actions drop-down menu are only ever applied to the single alert:
Using the Select button
Use the Select drop-down button to select large groups of alerts at once:
The Select option only applies to the current filtered view of your alerts. For example, if you are currently filtering the Alert Inbox to show only Medium Job failed alerts, and choose Read, then only Medium Job failed alerts that are marked as read are selected.
The Select drop-down list is context sensitive. If you are currently filtering the Alert Inbox to view only unread alerts, the Unread option will not be available.
Selecting alerts across multiple pages
When there are several pages of alerts, only the current page of alerts is selected by default. You can choose to apply the selection to all alerts on all pages:
If you choose this option, the message is updated:
Use the Older and Newer links to confirm that alerts are selected on other pages. Clicking Undo selection will undo the selection on all pages except the page where you first applied the selection.
Any actions you apply at this point, for example Mark as read, Clear, or Add comment will be applied to all selected alerts on all pages.
You can filter which alerts appear in the inbox by any of their attributes:
- by level (Low, Medium, High)
- by status (Event, Active, Ended, Cleared)
- by type (e.g. Job failed, Backup overdue, or any selection)
- by action taken (Read, Unread, Commented, No Comment)
- by time
SQL Monitor has built-in filters for the most common options you may want. You can also create your own filters using the Advanced filter pane.
See Filtering alerts.
Was this article helpful?
Thanks for your feedback!
- Example configuration of SQL Monitor using virtualization software
- Retrieving alert settings using SQL Data Compare
- Licensing issues with SQL Monitor
- Log files in SQL Monitor
- Upgrading to a later version of SQL Monitor
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
all SQL products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs