The Query Waits view displays the queries on your SQL Server instance with the longest wait times. By default, the chart at the bottom of the view displays the query waits over time and allows you to further investigate based on Statements, Applications, Databases, Clients, Sessions, and Users.
By analyzing these waits you can better determine where your biggest bottlenecks are occurring and what changes could potentially have the biggest performance boost on your SQL Server instance.
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.
Metric Calculation
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.