...
You can select to view query waits as the waits appear over time or by the duration of the wait, color-coded by the query. The chart includes each of the following wait type categories: Backup, I/O, Lock, Memory, Non-I/O Page Latch, Non-Page Latch, Transaction Log, and Other.
Access the Query Waits view
To pen the Query Waits view of the SQL Diagnostic Manager Queries tab, select the appropriate SQL Server instance, select Queries, and click Query Waits.
| Info |
|---|
|
Most values on the Query Wait Statistics graph correlate with the related SQL Server metric. However, It's important to note that some metric values like Wait Duration aggregate all the multiple calls to the SQL Server within the time intervals displayed on the graph. These aggregated values are then rounded off to present a clearer and more concise metric. |