SELECT
qs.last_execution_time AS LastExecutionTime,
st.text AS QueryText,
qs.execution_count AS ExecutionCount,
qs.total_worker_time / qs.execution_count AS AvgCPUTime,
qs.total_logical_reads / qs.execution_count AS AvgLogicalReads
FROM
sys.dm_exec_query_stats AS qs
CROSS APPLY
sys.dm_exec_sql_text(qs.sql_handle) AS st
ORDER BY
qs.last_execution_time DESC;
