DEADLOCK_TASK_SEARCH

Description

This wait is used internally by SQL Server. It is generated when SQL Server cannot perform deadlock searches. This typically occurs when searches are blocked by queries run on sys.dm_os_waiting_tasks. This wait type is uncommon and low values are acceptable

Resolved by

DBAs

Suggested solutions

  1. Check monitoring software. Ensure it is not querying sys.dm_os_waiting_tasks too much
  2. Examine the SQL Server error log for more information

Additional research

Deadlocking

⇐ Back to index