Platinum Sponsor

SQL Server Architecture: The life of a query

In this session I will be bringing together all the components of SQL Server to illustrate what happens when you issue a query from a client. From the TDS packet, through ODS, the optimizer and the buffer manager to returning the result. I'll walk you through when the transaction log is used, what happens when a checkpoint occurs and what the lazy writer does.I've illustrated the process in a way that's easy to consume and helpful to put SQL Server's architecture into context.
Presented by Christian Bolton at SQLBits IV
  • Downloads
    Video available WMV Video 63 MB
  • SpeakerBIO
    christian_bolton.jpg

    Christian Bolton is the Technical Director for Coeo Ltd, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is a Microsoft Certified Architect, Microsoft Certified Master and MVP for SQL Server, and lead author of Professional SQL Server 2012 Internals and Troubleshooting.

    http://sqlblogcasts.com/blogs/christian
  • Video