Advertisement
Guest User

Untitled

a guest
Aug 13th, 2018
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. into T1 FROM (
  2.       select top 100000
  3.       *
  4.       from
  5.       sys.dm_exec_query_stats qs
  6.       where qs.last_execution_time > (CURRENT_TIMESTAMP - '01:00:00.000')
  7.      order by qs.total_worker_time desc
  8.       --order by qs.max_elapsed_time desc
  9. ) as qs;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement