Microsoft SQL Server 2014 Unleashed

Delayed Durability for Transactions

To help reduce transaction related latency, SQL Server 2014 introduces the ability to designate some or all transactions as delayed durable. Fully durable transactions, the default in SQL Server from the beginning, return control to the client only after the log records for the transaction have been written to disk. A delayed durable transaction, on the other hand, returns control to the client before the transaction log record has been written to disk. Transaction durability can be controlled at the database level, COMMIT level, or ATOMIC block level. A more in-depth comparison of fully durable and delayed durable transactions and how they are managed, as well as when and how to implement delayed durability, ...