SQL Server에서 실행된 쿼리 보기

SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query]
FROM sys.dm_exec_query_stats AS deqs
	CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE 1= 1
AND dest.text like '%TABLE_NAME%'
ORDER BY deqs.last_execution_time DESC

[todo] spid, host등 추가적인 정보가 있으면 좋겠다.
dbcc inputbuffer 와 차이는?