--To Display the Top 25 Most expensive read I/O queriesSELECT TOP 25 cp.usecounts AS [execution_count] ,qs.total_worker_time AS CPU ,qs.total_elapsed_time AS ELAPSED_TIME ,qs.total_logical_reads AS LOGICAL_READS ,qs.total_logical_writes AS LOGICAL_WRITES ,qs.total_physical_reads AS PHYSICAL_READS ,SUBSTRING(text, CASE WHEN statement_start_offset = 0 OR statement_start_offset IS NULL THEN 1 ELSE statement_start_offset/2 + 1 END, CASE WHEN statement_end_offset = 0 OR statement_end_offset = -1 OR statement_end_offset IS NULL THEN LEN(text) ELSE statement_end_offset/2 END - CASE WHEN statement_start_offset = 0 OR statement_start_offset IS NULL THEN 1 ELSE statement_start_offset/2 END + 1 ) AS [Statement] FROM sys.dm_exec_query_stats qs join sys.dm_exec_cached_plans cp on qs.plan_handle = cp.plan_handle CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) st ORDER BY qs.total_logical_reads DESC;