Christian Bolton
cloudrede.com
Christian Bolton is a Microsoft Certified Architect, Microsoft Certified Master and former MVP for SQL Server with a penchant for Amazon Web Services. He leads the business at Cloud Rede.
WMV files are unsupported
SQLBits 2009
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.
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.