ASYNC_DISKPOOL_LOCK

Description

Occurs during parallel disk operations while SQL Server is waiting for threads to synchronize. This happens for operations such as backup, restore, file initialization (creation and growth). Small values are acceptable. Moderate values and average waits over 50ms should be investigated.

Resolved by

DBAs and Developers

Suggested solutions

  1. Enable Perform Volume Maintenance Tasks to avoid zero-initialization for data files
  2. Investigate storage issues in the Windows Event Viewer
  3. Ensure storage drivers are up to date

Additional research

Improving SQL Server Performance by using Instant File Initialization

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