Sometimes we need to get information about requests in SQL Server specially for log running query we need to know the status of the execution if it is blocked or not. To do this we could check the session id of from the log and check the status by using sys.dm_exec_requests
select * from sys.dm_exec_requests where session_id = 55; |
Status of the request has the following different values: Background, Running, Runnable, Sleeping, Suspended.
Here are some results