Guest User

Untitled

a guest
Nov 21st, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. SELECT TOP (25)
  2. SQLText.[Text] AS [Query Text],
  3. (total_logical_reads/execution_count) as [Average Logical Reads],
  4. (total_logical_writes/execution_count) as [Average Logical Writes],
  5. (total_physical_reads/execution_count) as [Average Physical Reads],
  6. Execution_count,
  7. statement_start_offset as [Statement Start Offset],
  8. sql_handle,
  9. plan_handle
  10. FROM sys.dm_exec_query_stats
  11. cross apply sys.dm_exec_sql_text(sql_handle) as SQLText
  12. ORDER BY (total_logical_reads + total_logical_writes) DESC
Add Comment
Please, Sign In to add comment