SQL查找占CPU高的语句

Peter12345 · 发表于 2018-12-14 14:26:04

SELECT TOP 50 SUM(qs.total_worker_time) AS total_cpu_time,SUM(qs.execution_count) AS total_execution_count,COUNT(*) AS number_of_statements,
(SELECT text FROM sys.dm_exec_sql_text(qs.sql_handle)) as sql_text
FROM sys.dm_exec_query_stats AS qs GROUP BY qs.sql_handle ORDER BY SUM(qs.total_worker_time) DESC

admin · 发表于 2018-12-14 15:55:57

建议楼主在发sql语句的时候，最好附上执行的截图，我给你加分

Peter12345 · 发表于 2018-12-14 16:40:48

下次会注意的，谢谢提醒

		自动登录	找回密码
密码			注册[Register]

[资料] SQL查找占CPU高的语句