Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Query waits over time view (click image to view full size) 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

...

Tip
titleAccess the Query waits by duration view

You can navigate to the Query waits by duration view by double-clicking any bar in this view.

...

The Query waits by duration view (click image to view full size) 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

...

Info
titleTime 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.

...

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  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >

...