select top 150 last_execution_time,total_worker_time as [total cpu time],
total_worker_time/execution_count as [Avg cpu time],execution_count,text, qp.query_plan
from sys.dm_exec_query_stats as qs cross apply sys.dm_exec_sql_text(qs.sql_handle)
as st cross apply sys.dm_exec_query_plan(qs.plan_handle) as qp
where datediff(hour,last_execution_time,getdate())<1
order by total_worker_time desc;