How to find all TSQL/Commands running on a server at a time?
This data is retrieved from DMV. Please execute below code:
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
This will show all the running codes on server at that point of time including vital parameters as status, SPID, cpu time, total elapsed time etc.
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
This will show all the running codes on server at that point of time including vital parameters as status, SPID, cpu time, total elapsed time etc.
Comments