The Query waits tab of the single instance dashboard allows you to analyze waits over time (Query Waits over Time) and by duration (Query Waits by Duration), so that 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.
Query waits over time
The Query waits over time view provides a selectable time range for the stacked bar chart display of waits. This view comes with various dimensions for display that allow you to further investigate any performance issues:
- Waits
- Waits Category
- Statements
- Applications
- Databases
- Clients
- Sessions
- Users
Access the Query waits by duration view
You can navigate to the Query waits by duration view by double-clicking any bar in this view.
Query waits by duration
The Query waits by duration view displays a horizontal bar chart of query waits by duration of the wait. This view comes with various dimensions for display that allow you to further investigate any performance issues:
- Waits
- Waits Category
- Statements
- Applications
- Databases
- Clients
- Sessions
- Users
Time range
In the Query waits by duration view, the horizontal bar chart is filtered by the selected time range in the Query waits over time view.
Access the query waits tab
To access the query waits enhanced views, click the monitored instance of your choice in the Home tab of the SQL Diagnostic Manager web console, and then select the Query Waits tab.