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
WMV Video 63 MB