Guest User

Untitled

a guest
Mar 19th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. SELECT st.text,
  2. qp.query_plan,
  3. qs.*
  4. FROM (
  5. SELECT TOP 50 *
  6. FROM sys.dm_exec_query_stats
  7. ORDER BY total_worker_time DESC
  8. ) AS qs
  9. CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
  10. CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) AS qp
  11. WHERE qs.max_worker_time > 300
  12. OR qs.max_elapsed_time > 300
Add Comment
Please, Sign In to add comment