Situatie
Mai jos este un query ce listeaza top 10 cele mai lungi, ca durata, query-uri rulate pe un server MSSQL de la ultimul restart al serverului.
Solutie
SELECT TOP 10
qs.total_elapsed_time / qs.execution_count AS [AvgExecTime],
qs.execution_count,
qs.total_logical_reads,
qs.total_worker_time / qs.execution_count AS [AvgCPUTime],
SUBSTRING(qt.text, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.text)
ELSE qs.statement_end_offset END
– qs.statement_start_offset)/2)+1) AS query_text
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
ORDER BY 1 DESC;
Leave A Comment?