Monitoring the status of SQL Servers

You can see all the SQL Servers you are currently monitoring and the connection status of each SQL Server in the Servers to show area in the Filter pane, at the top left of the application window:

If the Filter pane is not displayed, from the View menu, select Filter pane.

Yes in the Trace column indicates that SQL Response is collecting SQL Profiler trace data on that SQL Server.

A check mark next to a SQL Server name indicates that alerts or recommendations are being displayed for this SQL Server. See Viewing and filtering alerts and recommendations.

Status of monitored SQL Servers

The icon next to a SQL Server name indicates the current connection status and licensing status of the monitored SQL Server:

Move the mouse pointer over the icon next to a SQL Server name to view a tooltip containing more detailed information about the connection or licensing status of that SQL Server:

Alert bars on monitored SQL Servers

The colored alert bars next to a SQL Server name indicate whether there are any uncleared high level, medium level or low level alerts, or any recommendations, on this SQL Server:

The level at which an alert is raised is part of the alert's configuration, which you can change. If you have not edited the Default Template, the level at which each alert has been raised is determined by the configuration for those alert types in the Default Template. See Working with templates.

Note: the existence of cleared alerts on a SQL Server is not indicated by an alert bar, but cleared alerts can still be viewed. See Clearing alerts and adding comments.

How can I see what SQL Response is doing?

Whenever SQL Response communicates with the Alert Repository for a specific task, for example to refresh the display of alerts or retrieve alert details, the task status is displayed in the status bar at the bottom right of the application window: