mssql 쿼리실행이력/수행내역

버전 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;