Below query give us list of suspended Sessions in Database.
Select blocking_session_id,plan_handle,start_time,command,
wait_type,wait_time,percent_complete,row_count
from sys.dm_exec_requests S
where status='suspended' and database_id=DB_ID()
order by S.logical_reads desc
Note- sys.dm_exec_requests is the dynamic management view, which in inbuilt in SQL engine.
Comments
Post a Comment
If you have any doubt then please let me know in comment section.