The Query waits tab of the single instance dashboard allows you to analyze waits over time and 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.

The Statements by Duration and Statements by Wait Time charts display by default.  A drop-down menu allows you to further investigate waits based on Application, Databases, Clients, Sessions, and Users.

For more information on the query waits, see View query waits.


SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
  • No labels