Waitopedia is a comprehensive resource of information about SQL Server waits.

The description shown below is the top answer as voted by the Spotlight community.

The charts are based on 2.1 TB of data collected from 4207 instances uploaded by 323 Spotlight users over an 8 week period.


Category: Network
SQL Server versions: 2008, 2008 R2, 2012, 2014, 2016, 2017


1 Answer


This wait type is potentially a result from running the function fn_dump_dblog() to access log backups without having to restore the log backup.


This wait has never occurred recently

DUMP_LOG_COORDINATOR_QUEUE has not occurred recently on 4207 instances checked.

Prevalence of DUMP_LOG_COORDINATOR_QUEUE across the Spotlight Population