-- Examine schedulers
select * from sys.dm_os_schedulers

-- Query for current request's scheduler
select scheduler_id from sys.dm_exec_requests where session_id = @@spid

select * from sys.dm_os_wait_stats
select * from sys.dm_os_waiting_tasks

