SQL: list of waiting tasks

select * from sys.dm_os_waiting_tasks where session_id>50

SQL waiting stats

SELECT *
FROM sys.dm_os_wait_stats