Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on May 14, 2012
The SQL Server database engine uses latches for internal synchronization to critical operations. So why would you care about what a latch is? Well, if you have ever monitored a SQL Server closely, you know you can't escape latches. Come to this advanced session exploring the internals of how SQL Server uses the concept of latches for synchronization of key internal data structures. This talk is a very advanced "500" session that may include the use of advanced diagnostics such the Windows debugger and discussion of Windows APIs. I will assume the audience has a basic working knowledge of the SQL Server engine including an understanding of some of the more common SQL Server Engine DMVs such as sys.dm_exec_sessions, sys.dm_exec_requests and sys.dm_os_wait_stats.