The Details view displays a list of properties for the selected SQL Server instance, a list of the collected metrics and their characteristics, and provides a chart for you to graphically display metrics selected from the displayed list. For each metric, SQL Diagnostic Manager displays the current value, value range for reference, alert status, metric category, thresholds for each alert, and whether the metric is a custom counter. To add a metric to the Details chart, check the check box in the chart column for the appropriate metric.
All fields highlighted in the State column are associated with alerts. Right-click any of these metrics and select Configure Alerts to edit the associated thresholds.
Access the Details view
You can open the Details view of the SQL Diagnostic Manager Overview tab by selecting the appropriate SQL Server instance, and then clicking Overview > Details .
SQL Server instance properties area
The following properties are displayed for the selected monitored SQL Server instance.
Version
Indicates the current SQL Server version including service pack and build information on this SQL Server instance.
Edition
Indicates the current SQL Server edition, including Enterprise, Business Intelligence, or Standard, installed on this SQL Server instance.
Running
Indicates the timestamp associated with the most recent restart of this SQL Server instance.
Clustered
Indicates whether this SQL Server instance is part of a cluster. If it is part of a cluster, SQL Diagnostic Manager displays the name of the active node.
Processors
Indicates the total number of processors associated with this SQL Server instance and how many of these processors are currently in use.
Host
Indicates the name of the server hosting this SQL Server instance.
Host OS
Indicates the current operating system on the server hosting this SQL Server instance.
Host Memory
Indicates the total amount of memory on the server hosting this SQL Server instance.
Databases
Indicates the current number of databases on this SQL Server instance.
Data Size
Indicates the current size of the data on this SQL Server instance.
Log Size
Indicates the current size of the log files on this SQL Server instance.
VM Name
Indicates the name of the virtual machine on which this monitored SQL Server instance is running.
Virtualization Host Server
Indicates the name or IP address of the virtualization host server on which this virtual machine is running.
Host Memory
Indicates the total amount of memory on the host server on which this virtual machine is running.
Host Physical Processors
Indicates the total number of physical processors associated with the host server on which this virtual machine is running.
Host Logical Processors
Indicates the total number of logical processors associated with the host server on which this virtual machine is running. The number of logical processors is different from the number of physical processors only if the CPU on the host server supports Hyper-Threading.
Understanding your chart data and refresh interval
SQL Diagnostic Manager charts provide data whether collected real time or as part of a scheduled collection event. For additional information about how SQL Diagnostic Manager displays your chart data, see Charts.