Viewing and filtering alerts and recommendations

When SQL Response has been running for a short period, you should start to see a number of alerts being raised in the main list.

Note: All the examples in this topic refer to alerts; the list of recommendations can also be grouped, sorted, and filtered in the same way.

Switch between viewing alerts and recommendations by using the buttons in the main toolbar:

Grouping alerts by SQL Server

Select the Group by server check box on the main toolbar to collapse the list of raised alerts into SQL Server groups.

To view the alerts in a group, click , or double-click the group heading. Colored alert bars in the group heading indicate whether there are any alerts of high, medium or low level for that SQL Server, with the current selection of filters (including the current timeframe).

When there are no alerts to display for a SQL Server, given the current selection of filters, that SQL Server group is not displayed.

You can sort by column, within a group. Each expanded group is sorted separately.

Sorting alerts

Click a column header to sort the list of alerts by that column.

Filtering alerts

You can filter the list of alerts by selecting or clearing check marks for items in the Filter pane.

You can select any combination of filters.

The alert bars next to the SQL Server name in the Servers to show area are unaffected by any current filters that may be applied, including the timeframe filter.

In the above example, the alert bars in the Filter pane on the left indicate there are uncleared alerts at high, medium and low level on the two selected SQL Servers.

The alert bars in the list on the right reflect the current selection of filters, including the timeframe filter, and so indicate that there are just high and medium level alerts to view.

Note: switching the view from alerts to recommendations may change the selection of SQL Server filters; the SQL Server filters are saved separately for alerts and recommendations.

Using views

A view saves the current state of the Filter pane, that is, which check marks are selected. When you select the view from the Show box at a later date, these filters are instantly reapplied. You maintain one set of views for filtering alerts and another for filtering recommendations.

SQL Response has several predefined views available in the Show list, but you can create your own custom views. The predefined views cannot be deleted.

Note: The default views such as All servers & alerts or High level alerts always select all the monitored SQL Servers.

To save a set of filters as a view:

1. In the Filter pane, select the filters you want to save You can choose any combination of filters, for example, to show only high level Job type alerts on a specifed SQL Server, or to show all Blocked SQL process alerts across all your monitored SQL Servers.

   The Show list shows the last selected view with an asterisk, indicating that the selection of filters has been modified.

2. Click the save view button in the main toolbar.
3. In the Save View dialog box, type the name for the view. When you save a modified view, you can either save it with the same name to overwrite it, or change the name to create a new view. You cannot save a custom view with the name of a predefined view, for example Active alerts.

The view does not save the current timeframe, or the Group by server setting.

If you save a view that has all the SQL Servers selected, any new instances you subsequently add to SQL Response will not automatically be included in that view.