Measure CPU Pressure

CPU pressure is a state wherein the CPU is fully occupied with currently assigned tasks and there are more tasks in the queue that have not yet started.

SELECT

scheduler_id,

cpu_id,

current_tasks_count,

runnable_tasks_count,

current_workers_count,

active_workers_count,

work_queue_count,

pending_disk_io_count

FROM sys.dm_os_schedulers

WHERE scheduler_id < 255;