The Top Servers report identifies your worst performing SQL Server instances based on the number of active alerts for the current monitored instances, response time, CPU usage, memory usage, and disk usage.

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 attention.

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.

When to run this report

Run the Top Servers report daily to keep ahead of critical issues that can cause an unavailable instance.

How SQL Diagnostic Manager calculates metric values on this report

Most values on the Top Servers report correlate with the related SQL Server metric. However, some metric values represent averages over time. Likewise, a few metric values are based on performance algorithms that use multiple statistics to calculate a more accurate metric.You can access our Customer Support Portal for more information about the algorithm used to calculate a specific metric.

  • How is the Worst Performing and Most Frequent Queries information gathered? - Solution #00000412
  • How does SQL diagnostic manager gather statistics from monitored SQL Servers? - Solution #00000055
  • How does SQL diagnostic manager calculate the reorganization percentage for database tables? - Solution #00000301
  • What does the 'Memory Usage' metric in the Console and Reports represent? - Solution #00002237

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >