Study/Mssql2008. 8. 26. 17:33

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;
Posted by 영혼도둑