Top N=20 Queries - I/0
Panel Top N=20 Queries - I/O allows more advanced users to see which 20 processes are wasteful for discs.
The functionality is accessed on panel Performance in Administration panel.
The following is a description of the functionality of the form.
| Refresh |
Update the table with data for Top N=20 Queries - I/O. |
| Reset |
Clear the table with data for Top N=20 Queries - I/O. |
| execution_count |
Number of times that the plan has been executed since it was last compiled. |
| total_logical_reads |
Total number of logical reads performed by executions of this plan since it was compiled.
Will always be 0 querying a memory-optimized table. |
| last_logical_reads |
Number of logical reads performed the last time the plan was executed.
Will always be 0 querying a memory-optimized table. |
| min_logical_reads |
Minimum number of logical reads that this plan has ever performed during a single execution.
Will always be 0 querying a memory-optimized table. |
| max_logical reads |
Maximum number of logical reads that this plan has ever performed during a single execution.
Will always be 0 querying a memory-optimized table. |
| total_elapsed_time |
Total elapsed time, reported in microseconds (but only accurate to milliseconds), for completed executions of this plan. |
| min_elapsed time |
Minimum elapsed time, reported in microseconds (but only accurate to milliseconds), for any completed execution of this plan. |
| max_elapsed_time |
Maximum elapsed time, reported in microseconds (but only accurate to milliseconds), for any completed execution of this plan. |
| last_execution_time |
Last time at which the plan started executing. |
Displays the Queriees that was used.
 |
HINT
The query on which we clicked in the table above is displayed.
|