Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP (25)
- SQLText.[Text] AS [Query Text],
- (total_logical_reads/execution_count) as [Average Logical Reads],
- (total_logical_writes/execution_count) as [Average Logical Writes],
- (total_physical_reads/execution_count) as [Average Physical Reads],
- Execution_count,
- statement_start_offset as [Statement Start Offset],
- sql_handle,
- plan_handle
- FROM sys.dm_exec_query_stats
- cross apply sys.dm_exec_sql_text(sql_handle) as SQLText
- ORDER BY (total_logical_reads + total_logical_writes) DESC
Add Comment
Please, Sign In to add comment