Network Management

WRITELOG Sql Wait Type

This content will describe SQL Server wait type that can be encountered more or less commonly, which includes the description, steps that should be taken, and additional resources that could be used for troubleshooting.

First published date

10/8/2021 12:32 PM

Last published date

10/8/2021 12:32 PM

Overview

The WRITELOG wait time represents the time that accumulates while waiting for the content of the transaction log cache to be flushed to the physical disk that stores the transaction log file

Product section

Network Performance Monitor

Cause

Description

- Indicates SQL Server is waiting for transaction log disk writes to complete. If the value is high it could indicate a disk bottleneck on the volume hosting the transaction logs

- When a SQL Server session waits on the WRITE LOG wait type, it is waiting to write the contents of the log cache to the disk where the transaction log is stored. This is almost always a sign of poor disk performance. 

Resolution

Suggested solutions

  1. Upgrade storage volume hosting the transaction logs
  2. Disable any unused indexes. This will decrease the number of writes during data modifications
  3. Ensure that index fill factors are set appropriately to avoid page splits. Indexes that are frequently changing should have a lower fill factor
  4. Remove cursor or iterative procedures making many small changes. Replace these with batch modifications


The content posted herein is provided as a suggestion or recommendation to you for your internal use. The information set forth herein may come from third-party websites or customers. SolarWinds is not liable for any downtime or any issue that may occur if you perform the following suggestions on the link provided. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.