Page History
...
The Lock Waits panel tracks the total number of waits caused when a task is waiting to acquire a lock on your monitored SQL Server.
...
The Network panel tracks the performance of the network connection being used by your monitored SQL Server, and includes the following charts and gaugegauges:
- SQL Server Throughput
- VM Network Usage Throughput
- Host Network Usage Throughput
- Response Time
...
The Tempdb paneltracks the status of the tempdb database on your monitored SQL Server instance, and includes the following charts and gaugegauges:
- Tempdb Space Used
- Tempdb Contention
- Version Store Cleanup Rate
...
Indicates the status of the data is normal , or within the thresholds assigned to the metric.
...
If a metric on the Dashboard has no value , or displays as blank, SQL Diagnostic Manager is not able to collect the corresponding counter. Causes The causes of this situation include:
- The SQL Diagnostic Manager Console has not captured the metrics. It can take up to two refreshes for this capture to occur.
- OS metrics are disabled. SQL Diagnostic Manager requires direct WMI or OLE automation to collect data.
- If using OLE automationOLE automation, those procedures are unavailable. SQL Diagnostic Manager is unable to locate the required OLE automation stored procedures.
- If connecting to WMI directly, the WMI Service is not running. SQL Diagnostic Manager requires that the WMI service is running on the computer that hosts the SQL Server instance in order to collect OS metrics.
- The counters do not exist on this SQL Server instance.
...
The Dashboard view is refreshed according to the time set in the Server View Refresh field on the Console Options window, which is accessible by clicking Tools> Console Options.
...
SQL Diagnostic Manager charts provide data whether collected in real-time or as part of a scheduled collection event. For additional information about how SQL Diagnostic Manager displays your chart data, see see Charts.