Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can further filter your monitored instances by wait time with waits that exceed a defined Wait Threshold in milliseconds. Use this report to compile a list of instances that need immediate attentionThis report displays the values of the following metrics: Top Servers by Active Alerts, Top Servers by Response Time, Top Servers by CPU Usage, Top Servers by Memory Usage, Top Servers by Disk Usage, and Top Servers by Wait.

Note

A value of N/A indicates that the Collection service failed to collect data due to disabled OS metrics or a non-responsive WMI server. You must enable OS metrics monitoring to receive results.

...

Run the Top Servers report daily to keep ahead of critical issues that can cause an unavailable instance. Use this report to compile a list of instances that need immediate attention.

How SQL Diagnostic Manager calculates metric values on this report

...