Navigating in SQL Monitor

Top navigation bar

SQL Monitor contains four main areas, shown as tabs across the top of the screen:

OverviewsTab

When you click on a tab in the top bar, the landing page for the selected area is displayed. For example, clicking on Overviews takes you to the Global Overview, and clicking on Alerts takes you to the Alert Inbox. You can then drill down to view more detailed information.

Note: If you have clicked on a different tab, and want to return to your previous page instead of the landing page, use your browser's Back button. Clicking on a top level tab always starts you at the landing page. You can open pages in new tabs or windows if you want to view multiple pages simultaneously.

Monitored servers list

MonitoredServersLeftNav

The servers you are monitoring, and any groups you have created, are shown on the left side of the screen in various places in SQL Monitor: the overviews, the Alert Inbox and the alert settings pages.

Click on an object in the list to view the relevant overview or show only alerts/alert settings for the selected object. Click the arrow next to an object name to view levels beneath.

	Group
	Cluster
	Host machine (Windows server)
	SQL Server instance

In the Alert Inbox, you can continue to drill down to view databases. Clicking on a database shows alerts for the selected database.
When configuring alerts, you can also drill down to view individual jobs.
On the overviews, the number (n) after a group or server name shows the number of objects beneath. In the Alert Inbox, the number in brackets indicates the number of unread alerts.

Tip: If the names of your servers are truncated because they are too long, click to expand the width of the left pane.

Navigating in the Global Overview

Click on any object (server or database) in the Monitored servers list to view the Overview page for that object.
Click on a group to filter the Global Overview to show only servers in the selected group.
Click on the name of a host machine or SQL Server instance in the Servers column to go to the Overview page for that server. You can also click in the Status column.
Click on a number in the alerts summary panel at the top of the page to go to the Alert Inbox pre-filtered by your selection (e.g. High or Unread) across all servers.
Click on the colored bar graph under Uncleared alerts to go to the Alert Inbox to view alerts for that host machine or SQL Server instance:
Click on a sparkline graph for Processor time or Memory Used to go the Analysis page for those counters

Navigating in a server or database overview page

For a host machine, its monitored SQL Server instances are listed. Click in the Name or Status column to drill down to the SQL Server overview page.
For a SQL Server instance, all its databases are listed. Click in the Name or Status column for a database to drill down to the database overview page.
Click on Uncleared alerts, Unread alerts or Last 24hrs in the alerts summary panel at the top of the page to go to the Alert Inbox for all alerts relating to this object and everything below it in the hierarchy (e.g. for a host machine, it will show alerts for the machine as well as SQL Server instances and databases).
Click on Uncleared alerts, Unread alerts or Last 24hrs for a SQL Server instance or database to go to the Alert Inbox for alerts relating only to the specific object (e.g. a SQL Server instance) and levels below it, if applicable:
Click on any sparkline graph to go to the Analysis page for the selected metric:

Navigating in the Alert Inbox

In the Alert Inbox, you can filter the alerts that are displayed in two ways:

Select a server or database in the Monitored servers list on the left, and
Filter which alerts are shown, using a Global filter or a filter in the Filter panel

These two filters work in combination. For example, you can view all High level unread alerts on one instance raised in the last hour, or all Cleared alerts across all servers.

The number in brackets after a server or database name 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:

Unreadalerts

Click on any level to filter the list of alerts for that level and all levels below. (The alerts displayed will also depend on the filters you have selected.)

Viewing more alerts

When you first install SQL Monitor, the Alert Inbox shows a maximum of ten alerts per page. You can navigate through this list using the Newer and Older links:

The total number of alerts shown (...of n) is useful to indicate how many alerts match the current set of filters. Note that this will not necessarily match the number of unread alerts in the Monitored servers list.

To increase the number of alerts shown, use the Rows to display option below the inbox:

The Rows to display value is stored as a cookie in your browser.

Viewing alert details

To view the details for an alert, click anywhere in the row for that alert:

ClickonAnAlert

The alert opens in its own page, where you can review the detailed alert information and performance data. You can also apply various actions, for example, mark it as Cleared or add a comment.

Click in the Actions column to apply an action to an alert: