right now comparing and also found out the diff between the result between SP_who2 and sys.dm_os_waiting_tasks , now the sp_who2 return no blocking but sys.dm_os_waiting_tasks,
my sys.dm_os_waiting_tasks return 2 x blocking session by a process, the sys.dm_os_waiting_tasks's blocking session is the same as the blockby column returned by Sp_who2, right? which means which other resource the query is waiting for, right ?
what if the session_id and blocking session is about the same spid ? what is that mean ?
how to make result from sys.dm_os_waiting_tasks is the same as sp_who2 ?
please share on how you guy use sys.dm_os_waiting_tasks ! or other view can replay sp_who2 totally !