select top 1000 --创建时间 qs.creation_time, -- 查询 语句 substring(st.text,(qs.statement_start_offset/2)+1, ((case qs.statement_end_offset when -1 then datalength(st.text) else qs.statement_end_offset end - qs.statement_start_offset)/2) +
select top 1000 
--创建时间 
qs.creation_time, 
--查询语句 
substring(st.text,(qs.statement_start_offset/2)+1, 
((case qs.statement_end_offset when -1 then datalength(st.text) 
else qs.statement_end_offset end - qs.statement_start_offset)/2) + 1 
) as statement_text, 
--执行文本 
st.text, 
--执行计划 
qs.total_worker_time, 
qs.last_worker_time, 
qs.max_worker_time, 
qs.min_worker_time 
from 
sys.dm_exec_query_stats qs 
--关键字 
cross apply 
sys.dm_exec_sql_text(qs.sql_handle) st 
where 
qs.creation_time between '2012-12-03 09:00:00' and '2012-12-03 11:00:00' 
--and st.text like '%%' 
order by 
qs.creation_time desc
select top 1000 
--创建时间 
qs.creation_time, 
--执行文本 
st.text
from 
sys.dm_exec_query_stats qs 
--关键字 
cross apply 
sys.dm_exec_sql_text(qs.sql_handle) st 
where 
qs.creation_time between '2012-12-03 09:00:00' and '2012-12-03 11:00:00' 
and st.text not like '%select * from t_locationinfo where strcliplogicid in(%' 
order by 
qs.creation_time desc