Description
This wait type accumulates while the Log Manager is waiting for space to become available (via log truncation) to write transaction records to disk. If this wait type is high it indicates the transaction log is frequently running out of space
Resolved by
DBAs and Developers
Suggested solutions
- Preallocate transaction log files
- Increase the auto-growth from the default (less frequent growths)
- Remove cursor or iterative procedures making many small changes. Replace these with batch modifications
- Upgrade the volume the transaction log(s) are stored on
- Ensure that index fill factors are set appropriately to avoid page splits. Indexes that are frequently changing should have a lower fill factor. Page splits require additional transaction log records