Microsoft SQL Server Management Studio에서 직접 실행했던 쿼리

-- Microsoft SQL Server Management Studio에서 직접 실행했던 쿼리들만 보여준다.

SELECT
	db_name(st.dbid) DBName,
	object_schema_name(objectid, st.dbid) SchemaName,
	object_name(objectid, st.dbid) SPName,
	qs.total_elapsed_time,
	creation_time,
	last_execution_time,
	text
FROM
	sys.dm_exec_query_stats qs
CROSS APPLY
	sys.dm_exec_sql_text(qs.plan_handle)st
JOIN
	sys.dm_exec_cached_plans cp
ON
	qs.plan_handle = cp.plan_handle