select top 20 
qs.creation_time, 
last_execution_time,total_physical_reads,total_logical_reads,total_logical_writes,
DB_NAME(dbid) dbname,execution_count,--total_worker_time,last_worker_time,--substring(convert(char(23),DATEADD(ms,total_worker_time/1000,0),121),12,23) total_worker_time,--total_elapsed_time,last_elapsed_time,substring(convert(char(23),DATEADD(ms,total_elapsed_time/1000,0),121),12,23) total_elapsed_time,--total_elapsed_time / execution_count avg_elapsed_time,substring(convert(char(23),DATEADD(ms,(total_elapsed_time / execution_count)/1000,0),121),12,23) avg_elapsed_time,SUBSTRING(st.text, (qs.statement_start_offset/2) + 1,((CASE statement_end_offset WHEN -1 THEN DATALENGTH(st.text) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) + 1) AS statement_textFROM sys.dm_exec_query_stats AS qsCROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st--ORDER BY execution_count desc 计划执行总次数--ORDER BY total_elapsed_time --计划执行总时长order by last_worker_time desc;--最近一次执行cpu 占用时长