Page History
...
The Signature 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 - Begin and End, the Application, User, Database, Client, and the SQL Text you want to include or exclude from your results.
- Charts - The primary focus of the Signature Mode view is in the charts. The cart type drop-down allows you to pick a chart type: 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 chart by the following categories: By SQL Text, By Application, or By Database.
- Event Occurrences - It lists each occurrence of the query and the associated statistics, such as the Event Type, CPU Time (ms), Reads, Writes, SQL Text, Application, Avg. Duration (ms), Database, Avg. CPU Time, Reads as % of List, Avg. Writes, CPU as % of List, Writes as % of List, Avg. I/O Per Sec, Avg. Wait Time (ms), Avg. CPU Per Sec, Avg. Reads, Occurrences, Most Recent Completion, Avg. Blocking Time (ms), and Avg. Deadlocks.
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).
...
| 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). |
...