checking statistics on cached query plans

select s.text,

st.total_logical_reads,

st.total_physical_reads,

st.total_elapsed_time/1000000 secs,

st.total_logical_writes

from sys.dm_exec_query_stats st

cross apply  sys.dm_exec_sql_text(st.sql_handle) s

(thank you sql recipe book)