查询1:前10个代码最多需要时间 ; z. d( m0 ?2 e/ Hselect top 10 source_code, stats.total_elapsed_time/1000000 as seconds, last_execution_time from sys.dm_exec_query_stats as statscross apply(SELECT text as source_code FROM sys.dm_exec_sql_text(sql_handle)) AS query_textorder by total_elapsed_time descQuery2:占用物理读取次数最大的前10个代码! b$ f! T5 u$ D- r- l- _
select top 10 source_code, stats.total_elapsed_time/1000000 as seconds, last_execution_time from sys.dm_exec_query_stats as statscross apply(SELECT text as source_code FROM sys.dm_exec_sql_text(sql_handle)) AS query_textorder by total_physical_reads desc $ q) {3 F" A) k y2 T: ^解决方案: