In the Views section of the web console's dashboard you can see at a glance if there are any problems in your monitored SQL Server instances and drill-down for details. Each view is expandable and information is grouped By Status, By Tags, or by Most Critical Instances. SQLdm displays this information in the panel to the right.
In the By Status view you can easily identify the status of your monitored SQL Server instances and take action.
Instances are grouped as follows:
- All Instances
- Maintenance Mode
If you select all instances with an OK status in the By Status view, the panel displays information only pertaining to those instances.
In the By Tags view, you can view the status of different tags or group of instances, and drill-down to details. For example, verify if problems occur in the AlwaysOn, Mirroring or SQL 2005 servers (click image to view full size).
If you select the Mirroring tag in the By Tags view, the panel displays information only pertaining to those instances. For additional information on tags, see Work with tags.
By Most Critical Instances
The Most Critical Instances view lists all the critical SQL servers in your environment and provides links to the single instance dashboard so you can quickly review the issue. The instance with the largest number of alerts shows up at the top of the list.
If you click any of the listed critical instances, the single instance dashboard displays.