Versions Compared

Key

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

...

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, and query history 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.

...

Use the Filters section of the Signature Mode, Statement Mode, Query History, and Query History Waits views to pick the time range, what to include in the table, and even specific applications, client computers, databases, SQL text, and users to view.

...

Scroll pdf ignore
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >