select
db_name(ss.dbid) DBName,object_schema_name(objectid,ss.dbid) SchemaName,object_name(objectid,ss.dbid) StoredProcedure
,qq.total_elapsed_time,creation_time,last_execution_time,text,cc.objtype
from sys.dm_exec_query_stats qq cross apply sys.dm_exec_sql_text(qq.plan_handle) ss
join sys.dm_exec_cached_plans cc on qq.plan_handle = cc.plan_handle
where 
last_execution_time < getdate() -1 --ÇÏ·çÀü
and db_name(ss.dbid)='DB¸í' --DB¸í
and text like '%select%' -- Äõ¸®³» Æ÷ÇÔ ÅؽºÆ®
order by last_execution_time desc;