Ahmet AYDIN aydnahmet

## execution_plan_list
SELECT cp.bucketid,cp.size_in_bytes, st.text
FROM sys.dm_exec_cached_plans cp
CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st

## list_locked_table_and_queries
SELECT DTL.resource_type
	,CASE
		WHEN DTL.resource_type IN (
				'DATABASE'
				,'FILE'
				,'METADATA'
				)
			THEN DTL.resource_type
		WHEN DTL.resource_type = 'OBJECT'
			THEN OBJECT_NAME(DTL.resource_associated_entity_id, SP.[dbid])

## memory_buffer_execution_plan
go
checkpoint;
go
dbcc dropcleanbuffers;
go
dbcc freeproccache;
go
	SELECT cp.bucketid,cp.size_in_bytes, st.text
	FROM sys.dm_exec_cached_plans cp
	CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st
	SELECT DTL.resource_type
	,CASE
	WHEN DTL.resource_type IN (
	'DATABASE'
	,'FILE'
	,'METADATA'
	)
	THEN DTL.resource_type
	WHEN DTL.resource_type = 'OBJECT'
	THEN OBJECT_NAME(DTL.resource_associated_entity_id, SP.[dbid])
	go
	checkpoint;
	go
	dbcc dropcleanbuffers;
	go
	dbcc freeproccache;
	go