SELECT TOP 20 CAST((qs.total_worker_time) / 1000000.0 AS DECIMAL(28,2)) AS [Total CPU time(s)] , CAST(qs.total_worker_time * 100.0 / qs.total_elapsed_time AS DECIMAL(28,2)) AS [% CPU] , CAST((qs.total_elapsed_time - qs.total_worker_time)* 100.0 / qs.total_elapsed_time AS DECIMAL(28,2)) AS [% Waiting] , qs.execution_count AS [EXECUTE_COUNT] , CAST((qs.total_worker_time) / 1000000.0 / qs.execution_count AS DECIMAL(28,2)) AS [CPU time average(s)] , qt.text AS [QUERY] , DB_NAME(qt.dbid) AS [DatabaseName] , qp.query_plan FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp WHERE qs.total_elapsed_time>0 --ORDER BY [Total CPU time(s)] DESC Order yaparsan cok uzun suruyor
