Versions Compared

Key

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

...

Tip

To explore query data in multiple ways and get a handle on queries in your system, try our New advanced query views of the SQL Diagnostic Manager web console.

...

The Queries tab lists each event that occurs in the Query Monitor. For each event, among other details, SQL Diagnostic Manager lists the SQL text associated, start and end times, application, user information, and client computer associated with the event. Fields with SQL text hold 255 characters of text. To view the full SQL text, right-click the field and then select the appropriate option.
SQL Diagnostic Manager automatically assigns a name to each of your queries starting with Query 1. The name provides context to your query when switching from Signature Mode , Statement Mode, Query History, and Query Waits views.

Info

Query names are not persistent. The names are different on different desktops and in different sessions on the same desktop.

...

Tip

You can also view signatures in the Advanced query signature view of the SQL Diagnostic Manager web console.

...

You can access advanced filters by clicking the Filter button. These options include the ability to filter out specific applications, databases and SQL text from your query collection.

Tip

The Include incomplete queries filter in the Signature Mode and Statement Mode views is disabled by default. If you would like to include data with null values in these views, select the Include incomplete queries check box in the Filters section.

...