Versions Compared

Key

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

...

The Server Waits Chart displays the overall wait time for key areas on your monitored SQL Server instance.

Metric

Why it is important

I/O

Indicates the amount of input and output occurring on your SQL Server instance. A consistently high rate may indicate a higher risk of performance issues as the SQL Server processes wait for I/O to become available.

Locks

Indicates the wait time caused by locks on databases hosted by this SQL Server instance.

Log

Indicates the wait time related to database transaction logs.

Memory

Indicates all wait time related to memory operations.

Signal

Indicates that a SQL Server process is waiting for CPU time after the associated resources became available for processing.

Other

Indicates all lock waits not included in other categories and not excluded from monitoring.



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