The SQLOS scheduler has been a core feature of SQL Server ever since its appearance as the User Mode Scheduler in version 7.0. In this session you will learn what makes it tick, where lines of responsibility are drawn between schedulers, workers and tasks, and how everybody has their own selfish ideas about fairness.

We'll pay particular attention to synchronisation: the need to synchronise, the balancing act between busy waiting and context switching, and examples of internal SQLOS synchronisation primitives. All of this will complement your existing mental model of SQL Server waits.

It is a very deep session (stack traces and obscure functions will be aired!), but not a broad one. As long as you have a healthy interest in either SQL Server or operating system internals, you'll have a fair chance of following along.
(no tags)
The video is not available to view online.