The WRITELOG wait type means just what it sounds like: a DELETE, UPDATE, or INSERT (DUI) operation is waiting for the transaction log file to acknowledge a write request. There’s a simple fix: ease up on the DUIs. No? Alright, let’s check out our other options.
The WRITELOG wait type means just what it sounds like: a DELETE, UPDATE, or INSERT (DUI) operation is waiting for the transaction log file to acknowledge a write request. There’s a simple fix: ease up on the DUIs. No? Alright, let’s check out our other options.
To access this incredible, amazing content, you gotta get Fundamentals of Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.
- 01. How to Measure and Change Your SQL Server – 3 Metrics to Gather (23 minutes)
- 02. Measuring Your SQL Server with sp_BlitzFirst and Monitoring Software (24 minutes)
- 03. How to Measure and Change Your SQL Server – The Parts Catalog (7 minutes)
- Wait Types – ASYNC_NETWORK_IO (7 minutes)
- Wait Types – CXPACKET (54 minutes)
- Wait Types – LCK% – Locking Snapshot RCSI Part 1 (39 minutes)
- Wait Types – LCK% – Locking Snapshot RCSI Part 2 (29 minutes)
- Wait Types – PAGEIOLATCH Part 1 – Slow Reads from Storage (7 minutes)
- Wait Types – PAGEIOLATCH Part 2 – Ways to Mitigate It (9 minutes)
- Wait Types – RESOURCE_SEMAPHORE (33m)
- Wait Types – SOS_SCHEDULER_YIELD (44m)
- Wait Types – THREADPOOL (27m)