Microsoft SQL Server 2014 Unleashed

What’s New in Transaction Management

SQL Server 2014 introduces the ability to reduce transaction latency by designating some or all transactions as delayed durable. A delayed durable transaction (also known as lazy commit) returns control to the client before the transaction log record is written to disk. Fully durable transactions return control to the client only after the log records for the transaction are written to disk. This is the default transaction behavior in SQL Server. Transaction durability can be controlled at the database level, COMMIT level, or ATOMIC block level. This chapter will compare fully durable and delayed durable transactions and how they are managed, as well as when and how to implement delayed durability.