a guest Aug 13th, 2018 135 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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand