Versions Compared

Key

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

...

Tip

If queries appear on the Query Monitor views that you never want to appear, click Configure Query Monitor > Advanced and enter the applications, databases, or SQL text SQL text you want to exclude from the Query Monitor collection.

The Statement Mode view is where you go to drill-down into a specific execution of a particular query. Whereas the signature mode view provides a filtered look at your queries, the Statement Mode view provides all the detail you may need to diagnose a specific problem with a query. Once you find the problem query, History mode allows you to track the query over time and view trends.

...

In the Event Occurrences, each listed query has the option to view the Query Details, clickto open the Query Details window (if the iconis not colored, it means that there is no plan collected).

...

Note

In the Signature Mode view, right-click any of the listed queries under the Event Occurrences list and click Show Query Text to open the SQL Text window opens (In this window run a Query Diagnosis and receive a list of performance recommendations).

Tip
titleUnderstanding cell colors

Red in the column indicates that the data in that row represents 20% or more of the total data displayed in the list, while yellow indiscated indicated that the data in the row represents 5%or more of the total data displayed in the list.

...