Page History
...
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
You can open To pen the Query Waits view of the SQL Diagnostic Manager Queries tab by selecting , select the appropriate SQL Server instance, and then clicking Queries > Query Waits.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
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. |
...