Mark Broadbent has started a series on transaction durability. His first topic is the log buffer:
SQL Server is a highly efficient transaction processing platform and nearly every single operation performed by it, is usually first performed within memory. When operations are performed within memory, the need to touch physical resources (such as physical disk IOPS) are also reduced, and reducing the need to touch physical resources means those physical boundaries (and their limitations) have less impact to the overall system performance. Cool right?!
Click through to read more about how log buffers work and why they help improve SQL Server’s performance.