Inside SQL Waits, Latches, and Spinlocks - Bob Ward

Dive into the internals of waits in SQL Server including latches and spinlocks. In this session, you will learn how SQL Server implements waits, how you can monitor and troubleshoot waits, and a deep dive into specific common wait types. This session will include new wait types specific to Azure SQL. This session is not for the faint of heart as it will be fast and furious. The session will include plenty of demos and back by popular demand the use of the Windows Debugger to peek inside how waits are truly implemented in SQL Server!

[zumado]

Hope Bob never retire. Every session he is in is great. Such a knowledgeable guy actually knows about SQL server.