[SQL Server] Sessions en cours – CPU time (ms) depuis le début de la session
/* Sessions en cours – CPU time (ms) depuis le début de la session */
SELECT session_id,
status,
cpu_time/1000.0 AS cpu_seconds,
total_elapsed_time/1000.0 AS elapsed_seconds,
logical_reads,
reads,
writes,
wait_type,
wait_time/1000.0 AS wait_seconds,
SUBSTRING(st.text,
(r.statement_start_offset/2)+1,
((CASE r.statement_end_offset
WHEN -1 THEN DATALENGTH(st.text)
ELSE r.statement_end_offset END
- r.statement_start_offset)/2)+1) AS sql_text
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st
WHERE r.session_id <> @@SPID -- exclure la requête qui interroge
ORDER BY cpu_time DESC;