Cacher is the code snippet organizer for pro developers

SELECT TOP 10
    total_logical_reads, total_logical_writes, execution_count,
    total_logical_reads + total_logical_writes AS [IO_total],
    b.text AS query_text, DB_NAME(b.dbid) AS database_name,
    b.objectid AS object_id
FROM
    sys.dm_exec_query_stats a
    CROSS APPLY sys.dm_exec_sql_text(sql_handle) b
WHERE
    total_logical_reads + total_logical_writes > 0
ORDER BY
    [IO_total] DESC;