Author: Peter Whyte

⏳Part of the SQL Server Wait Types Library, every wait type explained.Related pillar: Storage & Capacity PAGEIOLATCH_EX is the exclusive (write) variant of the page I/O latch wait. Where PAGEIOLATCH_SH means SQL Server is waiting to read a page from disk into the buffer pool, PAGEIOLATCH_EX means SQL Server is waiting to write a dirty…

⏳Part of the SQL Server Wait Types Library, every wait type explained.Related pillar: Performance & Troubleshooting These wait types mean queries are blocked waiting for locks held by other sessions: High values for any of these mean blocking is happening regularly and accumulating significant wait time. Is This Wait Expected? Small amounts of locking are…

⏳Part of the SQL Server Wait Types Library, every wait type explained.Related pillar: Storage & Capacity IO_COMPLETION covers I/O waits that happen outside the normal buffer pool page path. Where PAGEIOLATCH_SH and PAGEIOLATCH_EX track data page reads and writes through the buffer pool, IO_COMPLETION tracks everything else: sort spills to tempdb worktables, backup file writes,…

⏳Part of the SQL Server Wait Types Library, every wait type explained.Related pillar: High Availability HADR_SYNC_COMMIT appears exclusively on Always On Availability Group primary replicas configured with at least one synchronous commit secondary. With synchronous commit, the primary cannot acknowledge a transaction commit to the application until the log records for that transaction have been…

⏳Part of the SQL Server Wait Types Library, every wait type explained.Related pillar: Performance & Troubleshooting CXPACKET and CXCONSUMER appear whenever SQL Server runs a query using parallelism. They are the coordination overhead between parallel worker threads, not actual resource waits. They almost always appear together. If you’re on a build older than SQL Server…