Exploring SQL Server Internals through WinDbg & XPerf
Do you ever wanted to know how SQL Server internally works together with the Windows Operating System? If yes, then you are right in this session. In this session we will use WinDbg - the offical Microsoft Windows Debugger - and XPerf to dig into SQL Server to get a better understanding how SQL Server is internally implemented. In this session we will a deep dive into the internals of SQL Server. We will analyze a lot of different call stacks, and you will see how SQL Server implements things like Thread Scheduling, asynchronous I/O Completion Ports, and Memory Management from the OS perspective in combination with the implementation in SQL Server.
Sorry, there are no downloads available for this session.
Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.
The video is not available to view online.