摘要:
-- 平均物理读次数最多的SQL语句:select top 50 *, (s.total_physical_reads / s.execution_count) as avephysicalreads from sys.dm_exec_query_stats scross apply sys.dm_exec_sql_text(s.sql_handle)order by avephysicalreads desc-- 平均逻辑读次数最多的SQL语句:select top 50 *, (s.total_logical_reads / s.execution_count) as avglogical 阅读全文