LOGBUFFER

Description

Indicates SQL Server is waiting for a log buffer to write log blocks for a transaction. Log buffers often deplete when a lot of small transactions (implicit or explicit) are happening very frequently

Resolved by

DBAs and Developers

Suggested solutions

  1. Remove cursor or iterative procedures making many small changes. Replace these with batch modifications
  2. See if the database setting Delayed Durability is suitable for the database system
  3. Disable any unused indexes. This will decrease the number writes during data modifications
  4. Ensure that index fill factors are set appropriately to avoid page splits. Indexes that are frequently changing should have a lower fill factor

Additional research

Delayed Durability in SQL Server 2014
Diagnosing Transaction Log Performance Issues and Limits of the Log Manager
What is the WRITELOG wait type

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index