select * from sys.dm_os_waiting_tasks
select * from sys.dm_os_wait_stats
---- compute cpu resource waits
select wait_type, waiting_tasks_count, 'total waits'=
[wait_time_ms],'total signal=CPU waits'=[signal_wait_time_ms]
,'CPU resource waits % = signal waits / total waits'=cast (100*[signal_wait_time_ms]/CASE WHEN [wait_time_ms] = 0 THEN 1 ELSE [wait_time_ms] END as numeric(20,1))
from sys.dm_os_wait_stats
where substring([wait_type],1,12) = 'PAGEIOLATCH_'
