The Server tree contains all the SQL Server instances for the selected view, and allows you to drill down to the specific SQL Server components. Selecting these components opens corresponding views, providing detailed information.

The Server tree also displays tags, which are a way of labeling and organizing servers.The tree shows the defined tags and highlights when servers within the tag are in an alert state. Select a tag to show a filtered view of the servers within that tag.

SQL Server instances in the Server tree also display status icons. When a SQL Server instance is associated with a warning or critical metric icon, use your mouse cursor to hover over the server name to view the top three associated alerts. This feature allows you to prioritize your SQL Server instances and the work that you need to perform.

A full refresh of alerts excluding table fragmentation occurs in the following circumstances even if longer collection intervals are defined:

  • When the collection service starts
  • When the collection service receives a new workload, such as redirecting the Management Service to a new Repository
  • When you add a SQL Server for collection
  • When a SQL Server resumes from Maintenance Mode
  • When a user selects Refresh Alerts

This refresh does not cause collection of non-alertable data, nor cause collection of anything that is disabled.

When you select a SQL Server instance in the Server tree, the Overview tab opens.

The Overview tab contains the following options:

 The Dashboard view is where you can see a graphical representation of the most important metrics for the selected SQL Server instance.

 The Details view lets you view the values of each data item collected and create charts with the specific data items you need.

 The Configuration view allows you to view and control the operational configuration of the monitored SQL Server instance.

 The Active Alerts view   allows you to view and control the active alerts as of the most recent data collection.

 The Timeline view allows you to view all alerts and maintenance mode events as well as the first monitored event for the selected SQL Server instance.

By right-clicking a SQL Server instance in the Servers tree you can perform the following actions:

 Opens the Dashboard view for the selected monitored SQL Server instance.

 Gathers the alert status and refreshes the tree view information for the selected monitored SQL Server instance.

 Allows you to delete the SQL Server instance from your SQL Diagnostic Manager installation. When you select Delete, SQL Diagnostic Manager displays a message asking whether you want to retain the collected data for the SQL Server instance, and it also allows you to cancel out of the deletion process.

You cannot retrieve collected data once it is deleted from the SQL Diagnostic Manager Repository. Use the Delete option with care.

 Allows you to take an individually monitored SQL Server instance offline for scheduled maintenance or other reasons.

 Allows you to configure the performance baseline for the selected SQL Server instance.

 Allows you to select an existing alert template to apply to the selected SQL Server instance.

 Allows you to specify the alert criteria for each collected metric on the selected SQL Server instance.

 Allows you to snooze all the alerts for the selected SQL Server instance instead of selecting the snooze feature for each alert individually.

 Allows you to resume any alerts set to snooze on the selected SQL Server instance.

 Allows you to view and edit the collection properties of your SQL Server instance.