Logging behavior changes when you enable delayed_commit.
The user log cache (ULC) is flushed to the transaction log in memory.
The task issues writes on all non-written log pages except the last (which contains the commit).
The task notifies the client application of a successful commit without waiting for the I/O to complete.
By another transaction when it is no longer the “last log page.”
By another, non-delayed transaction when it completes.
By a checkpoint or the housekeeper buffer wash mechanism.
By implicit checkpoints causes (for example, shutdown, dump database, dump tran, sp_dboption truncate log on checkpoint).
The task is ready to continue with the next transaction.