Versions Compared

Key

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

The Server Waits panel tracks the total number and time spent on waits affecting your monitored SQL Server. Unexpected spikes in the number of server waits may warn you about the beginning of a serious performance issue. Chronically high server wait times may indicate the need for server maintenance, query tuning, or index updates to better handle the ongoing workload. For additional information, see how to view View server waits.

Tip

Server Waits chart data is not available for monitored servers using SQL Server 2000. For SQL Server 2000 users, SQL Diagnostic Manager monitors lock waits.

...