What is write-ahead logging (WAL)?

Write-ahead logging means SQL Server writes the log record describing a data modification to stable log storage before the associated modified data page is written to the data file.

This allows SQL Server to recover committed transactions and undo incomplete transactions after a crash. Data pages can remain modified in memory for some time after commit, while the required transaction log records have already been hardened according to the durability model.