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. |
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 .
The following properties are displayed for the selected monitored SQL Server instance.
Indicates the current SQL Server version including service pack and build information on this SQL Server instance.
Indicates the current SQL Server edition, including Enterprise, Business Intelligence, or Standard, installed on this SQL Server instance.
Indicates the timestamp associated with the most recent restart of this SQL Server instance.
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.
Indicates the total number of processors associated with this SQL Server instance and how many of these processors are currently in use.
Indicates the name of the server hosting this SQL Server instance.
Indicates the current operating system on the server hosting this SQL Server instance.
Indicates the total amount of memory on the server hosting this SQL Server instance.
Indicates the current number of databases on this SQL Server instance.
Indicates the current size of the data on this SQL Server instance.
Indicates the current size of the log files on this SQL Server instance.
Indicates the name of the virtual machine on which this monitored SQL Server instance is running.
Indicates the name or IP address of the virtualization host server on which this virtual machine is running.
Indicates the total amount of memory on the host server on which this virtual machine is running.
Indicates the total number of physical processors associated with the host server on which this virtual machine is running.
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.
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.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|