Activity | Historical | Longest Duration

Lists the top 50 most expensive queries based on duration. This retrieves queries for which the execution plan is still in the cache.

What It ShowsComments
Database
Last executionThe last time the query ran
Number of executions
Total CPU time
Average CPU time
Max CPU time
Total elapsed time
Average elapsed time
Max elapsed time
Total logical reads
Average logical reads
Max logical reads time
Total logical writes time
Average logical writes time
Max logical writes time
SQL textThe query text
< Activity | Historical | Highest CPU Activity | Historical | Most Logical Reads >