[DMV] Top I/O Queries

-- top 5 I/O

SELECT top 5

             (total_logical_reads/execution_count) AS avg_logical_reads,

             (total_logical_writes/execution_count) AS avg_logical_writes,

             (total_physical_reads/execution_count) AS avg_phys_reads,

             execution_count,

             statement_start_offset AS stmt_start_offset,

             sql_text.text,

             query_plan.query_plan

FROM     sys.dm_exec_query_stats a

             CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sql_text

             CROSS APPLY sys.dm_exec_query_plan(plan_handle) AS query_plan

ORDER BY (total_logical_reads + total_logical_writes) DESC