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.



SQL Diagnostics Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal