Page History
...
The Statement Mode view is displayed as follows:
- Filter - Use Query filters to narrow the results to only those that most interest you. Do this by selecting the Date Range - Being and End, Application, User, Database, Client, and the SQL Text you want to include or exclude from your results.
- Charts - The primary focus of the Statement Mode view is in the charts. The charts type drop-down allows you to pick a chart type to display: Average Duration, Average CPU, Average Reads, Average Writes, Average Waits, Deadlocks, Blocking, CPU Per Second, and I/O Per Second. Also, you can choose to view the type of charts by the following categories: By SQL Text, By Application, By Database, By User, and By Client.
- Event Occurrences - It lists each occurrence of the query and associated statistics, such as the Event Type, CPU Time (ms), Reads, Writes, SQL Text, User, Application, Duration (ms), Database, Avg. CPU Time (ms), Avg. Writes, Avg. I/O per sec, Wait Time (ms), Avg. CPU Per Sec, Avg. Reads, Start Time, End Time, Blocking Time (ms), Deadlocks, Client, and Speed.
In the Event Occurrences, each listed query has the option to view the
...
Query Details, click
...
to open the Query Details window (if
...
the icon
...
is not colored, it means that there is no plan collected).
The primary focus of the Statement Mode view is in the charts. The chart type drop-down allows you to pick a chart type to display, while the chart category drop-down allows you to choose to view the data by SQL Text, Application, Database, User, or Host. Click a query in a chart to open up the query history for that query.
Use Query filters to narrow the results to only those that most interest you. Do this by selecting the data and time range, the application, user, database, workstation and even the SQL text you want to include or exclude from your results.
...
| Info | ||
|---|---|---|
| ||
The Sigma character indicates that the data in this row is at least partially composed of aggregated data. This means that the data is condensed into a day-length summary and some precision about the individual statements, client computers, and users is suppressed. Rows in this view with the Sigma character may include a mix of aggregated and non-aggregated data. |
| 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 | ||
|---|---|---|
| ||
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 that the data in the row represents 5%or more of the total data displayed in the list. |