How to find all the session for particular plan_handle or sql_hash in SQL Server

Asked Oct 03 '18 at 14:37

Active Jan 23 '20 at 14:26

Viewed 135 times

How to find all the session for particular plan_handle or sql_hash in SQL Server?

edited Jan 23 '20 at 14:26

Vadzim

asked Oct 03 '18 at 14:37

Hima Joshi

Does [`sys.dm_exec_requests`](https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-requests-transact-sql?view=sql-server-2017) help? Perhaps adding some details to your "question", e.g. the results you expect and what you've tried, would help us help you. – HABO Oct 03 '18 at 15:31
i want to kill those all running session who is related to specific plan_handle or sql_hash for my one of the task.I already tried to use sys.dm_exec_requests dmv but it always showing null. Is there any other way to find session? – Hima Joshi Oct 04 '18 at 06:17
Here is the solution: https://stackoverflow.com/questions/37252753/automatically-kill-session-of-some-specific-task/55752789#55752789 – Vadzim Jan 23 '20 at 14:28

0 Answers0