Top N=20 Queries - CPU
Panel Top N=20 Queries - CPU allows more advanced users to see which 20 processes are wasteful for processes that burden the processor.
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 - CPU. |
| Reset |
Clear the table with data for Top N=20 Queries - CPU. |
| sql_handle |
Is a token that uniquely identifies the batch or stored procedure that the query is part of.
sql_handle, together with statement_start_offset and statement_end_offset, can be used to retrieve the SQL text of the query by calling the sys.dm_exec_sql_text dynamic management function. |
| execution_count |
Number of times that the plan has been executed since it was last compiled. |
| Total_CPU |
Total amount of CPU time, reported in microseconds (but only accurate to milliseconds), that was consumed by executions of this plan since it was compiled.
For natively compiled stored procedures, total_worker_time may not be accurate if many executions take less than 1 millisecond. |
| total_CPU_inSeconds |
Converted from microseconds in seconds (total_CPU/1000000). |
| average_CPU_inSeconds |
Converted from microseconds in seconds (total_CPU/1000000) / qs.execution_count). |
| total_elapsed_time |
Total elapsed time, reported in microseconds (but only accurate to milliseconds), for completed executions of this plan. |
| total_elapsed_time_inSeconds |
Total elapsed time, reported in seconds, for completed executions of this plan. |
Displays the Queriees that was used.
 |
HINT
The query on which we clicked in the table above is displayed.
|