버전MSSQL2008기준 select TOP 100 sqlText.text, queryStats.last_execution_time, queryStats.creation_time, queryStats.execution_count, queryStats.total_elapsed_time from sys.dm_exec_query_stats as queryStats cross apply sys.dm_exec_sql_text(queryStats.plan_handle) as sqlText order by queryStats.last_execution_time desc;