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

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