Page History
...
You can select to view query waits as the waits appear over time or by duration of the wait, color coded by 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, select Queries, and then clicking Queries > click Query Waits.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...