Inside SQL Server Latches (90 mins)
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.
Principle Escalation Engineer
Bob Ward is a principal escalation engineer in Microsoft Customer Service and Support (CSS) based in the Microsoft Regional Support Center in Irving, Texas. He has worked with Microsoft since 1993 and has now supported every release of Microsoft SQL Server from 1.1 for OS/2 to SQL Server 2008. Bob has been presenting topics on SQL Server at the PASS Summit since 2003. His background in the computer industry spans 22 years and includes database development projects with companies like General Dynamics, Harris Hospital, and American Airlines. Bob graduated with a bachelor’s degree in computer science from Baylor University in 1986. Bob has co-authored the book SQL Server 2005 Practical Troubleshooting: The Database Engine including chapters on advanced data recovery and troubleshooting critical errors. He now authors and directs one of the most popular blog sites for SQL Server advanced users at http://blogs.msdn.com/psssql.
Register Now for PASS Summit 2010!