Page History
Query History allows you to track the performance of a query over time. To access the Query History view, select the query you want to see on the query statement mode or signature mode view in the graph. You can also access the Query History view by right-clicking a session on the Session Details view or a Statement on the Query Waits view and selecting Show Query History.
Access the Query History view
You can open the Query History view of the SQL Diagnostic Manager Queries tab by selecting the appropriate SQL Server SQL Server instance , and then clicking Queries > Query History.
View Query History
- Use the drop-down menu on each chart to view the history of each of the metrics associated with the query: Average Duration, Average CPU, Average Reads, Average Writes, Average Waits, Deadlocks, Blocking, CPU Per Second, and I/O Second.
- Click View SQL TextSQL Text to see the associated query text.
- Click Aggregate History to keep an aggregated history for the selected query.
Use Query filters to narrow the results to only those that most interest you. Do this by selecting the data date and time range, the application, user, database, workstation, and even the SQL text SQL text you want to include or exclude from your results.
Event Occurrences is a list of each occurrence of the query and the associated statistics, such as the duration, CPU time, reads, writes, and associated SQL textSQL text. Click the Maximize window icon to view a larger version of this list.
...
| 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 indicates that the data in the row represents 5%or 5% or more of the total data displayed in the list. |
...