|
1 2 3 4 5 6 7 8 9 |
SELECT sqltext.TEXT, req.session_id AS 'SPID', req.status AS 'Status', req.command AS 'Command', req.cpu_time AS 'CPU Time', req.total_elapsed_time/1000 AS 'Total Elapsed Time in Seconds' FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext ORDER BY [CPU Time] DESC |
Views – 2200