SELECT TOP 50
total_worker_time/execution_count/1000000 AS [Avg CPU Time],
(SELECT text FROM sys.dm_exec_sql_text(sql_handle)) AS query_text, *
FROM sys.dm_exec_query_stats
ORDER BY [Avg CPU Time] DESC
转载于:https://www.cnblogs.com/pugster/archive/2012/09/25/2701314.html