SQL DMV Shows the waiting task both current and historical
select * from sys.dm_os_waiting_tasks select * from sys.dm_os_wait_stats