Uzun Sure Calisan Sorgular - Long wait Query ISMAIL
Definition Description
SELECT TOP 20 CAST(qs.total_elapsed_time / 1000000.0 AS DECIMAL(28,2))AS [TOTAL DURATION (s)] , CAST(qs.total_worker_time * 100.0 / qs.total_elapsed_time AS DECIMAL(28,2)) AS [% CPU] , qs.execution_count [EXECUTE_COUNT] , CAST(qs.total_elapsed_time / 1000000.0 / qs.execution_count AS DECIMAL(28,2)) AS [AVERAGE DURATION (s)] , SUBSTRING(qt.text,(qs.statement_start_offset/2)+1, ((CASE WHEN qs.statement_end_offset=-1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text))*2 ELSE qs.statement_end_offset END - qs.statement_start_offset)/2)+1) AS [Individual Query] , qt.text AS [Parent Query] , 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 qs.total_elapsed_time DESC
