Consulta dos ultimos comandos executados

SELECT
qs.creation_time,
qs.last_execution_time,
qs.execution_count,
qt.text AS sql_text,
qp.query_plan
FROM
sys.dm_exec_query_stats AS qs
CROSS APPLY
sys.dm_exec_sql_text(qs.sql_handle) AS qt
CROSS APPLY
sys.dm_exec_query_plan(qs.plan_handle) AS qp
ORDER BY
qs.last_execution_time DESC;