How to show blocking information using sys.dm_tran_locks & sys.dm_os_waiting_tasks and Linking session information to operating system threads
How to Returns information about currently active lock manager resources in SQL Server 2017 Q:- Columns that are returned by sys.dm_tran_locks relat…