查询1:前10个代码最多需要时间 0 `7 D: h- W* ^) |! X1 l) jselect 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个代码 ( P G( G( E9 Jselect 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 1 P( \+ f% G1 x6 R解决方案:
技术问答
143 人阅读
|
0 人回复
|
2023-09-13
