IO_QUEUE_LIMIT is a wait recorded when a session cannot issue another asynchronous I/O because its queue of outstanding async I/Os is already at its limit. The engine caps how much async I/O a single task can have in flight; when the cap is hit, the task waits here until some of the in-flight I/O completes.
You will meet this wait mostly in Azure SQL Database, where I/O governance actively limits throughput per database tier, but throttled I/O paths exist on-premises too.
Is It a Problem?
It is a throughput ceiling, so it depends where the ceiling comes from. In Azure SQL Database, sustained IO_QUEUE_LIMIT (usually alongside LOG_RATE_GOVERNOR or high PAGEIOLATCH_*) means the workload wants more I/O than the service tier provides; the fix is either a lighter workload or a bigger tier. On-premises appearances are rarer and typically accompany operations that flood the async I/O path, like enormous scans or checkpoint bursts against slow storage.
Either way, the wait itself is honest: I/O demand exceeded the allowed queue depth.
Common Causes
- Azure SQL Database service tier I/O limits throttling a busy workload.
- I/O-hungry operations, large scans, bulk loads, index rebuilds, issuing async I/O faster than the subsystem completes it.
- Slow storage stretching completion times, keeping the queue full longer.
What To Do
- In Azure, check resource governance telemetry (
sys.dm_db_resource_stats, avg_data_io_percent) to confirm you are riding the tier’s I/O ceiling. - Reduce the I/O appetite first: missing indexes turn seeks into scans, and scans are what flood the queue. Cheaper than a tier upgrade.
- If the workload is already lean, scale the tier (or storage performance on-premises) to match real demand.
- Schedule the I/O-heavy maintenance (rebuilds, integrity checks) away from peak hours so they are not competing for the same queue.
How To See It
Rank it against everything else with Get-WaitStatistics, and in Azure pair it with sys.dm_db_resource_stats to see how close to the governor you are running.
Part of the SQL Server Wait Types Library.
Related deep dive: IO_COMPLETION Wait Type.
Leave a Reply