SQL Monitor 13

Using the Alert Inbox

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 2 minutes. You do not need to manually refresh your browser.

The status of each alert is shown in the Status column:

Alert times displayed in SQL Monitor

All alert times in SQL Monitor are displayed in the local time of your web browser, regardless of where the Base Monitor server or your monitored servers are located. For example, if an alert is raised on a server in London at 18:00 and you are using SQL Monitor in New York, the alert time will be displayed as 13:00 (local time for New York).

Alert severities

Each alert or group of alerts is color-coded to indicate its severity. Red indicates high, orange medium and blue low. The severity is the highest severity the alert or group of alerts achieved. If an alert is configured with a range of thresholds, and the alert was progressively medium, then high, then finally medium before ending, the alert inbox will highlight the alert with a red indicator. This, for example, would highlight a severe situation that occurred overnight when you start work in the morning. This is in contrast to the global dashboard, which indicates the current state of your servers: the global dashboard shows the current state of any alert.

Grouping and ungrouping alerts

When you first install SQL Monitor, the Alert Inbox shows your alerts in groups. Alerts are grouped together by Alert Type and the object the alert was raised on, e.g.:

  • Disk space usage alerts are grouped by Machine and Disk.
  • Backup Overdue alerts are grouped by Database.
  • Long Running Queries are grouped by query text.
  • etc.

This view allows you to see more about what's happening on your estate at a glance.

Each group shows details about the group as well as the latest alert within the group.

To see the alerts in each group, you can click its row. To go back to the Alert Inbox, click the ← Alert Inbox link at the top left.

You may want to see your alerts ungrouped, so you can better see the order in which individual alerts are raised. 

To do this switch the Group Alerts toggle off.

If you want to switch to the grouped view again, switch the Group Alerts toggle back on.

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 Page size option below the inbox:

Filtering Alerts

When you first click the Alerts tab, SQL Monitor always shows every uncleared alert across all your servers.  However, you can then filter the alerts that are displayed in the Alert Inbox in a variety of ways.

For a full details of this topic see: Filtering alerts

How alerts are sorted in the Inbox

Event type alerts are sorted by the date they are raised. Continuous alerts (with the status Active or Ended) are sorted by the date they were raised, the last time their severity increased, or when they ended.

Groups are sorted by the date of the most recent alert in the group.

Actions you can apply to alerts

To:

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.

Open an alert in a new tab

Right-click on the alert and select Open in new tab.

Mark an alert as read

(only available for alerts that are currently unread)

Go to the Alert Details page (Alerts are automatically marked as Read when you visit this page).

Select the alert using its checkbox:

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)

Select the alert using its checkbox 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)

Select the alert using its checkbox then click the Clear button.

This is useful when clearing multiple alerts.

Select one or more alerts

Select the checkbox  next to each alert.

Use Shift + Click to select a block of alerts.

Configure an alert

Go to the Alert Details page and click Configure Alert... in the top right.

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. SeeCustomizing alerts.

Selecting 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 checkbox  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:

Clearing or reading a selection of alerts may remove them from the Alert Inbox, depending on the current filter settings.

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 page of your filtered view. 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 will be applied to all selected alerts on all pages.


Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?