sys.dm_io_pending_io_requests (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns a row for each pending I/O request in SQL Server.


To call this from Azure SQL Data Warehouse or Parallel Data Warehouse, use the name sys.dm_pdw_nodes_io_pending_io_requests.

Column name Data type Description
io_completion_request_address varbinary(8) Memory address of the IO request. Is not nullable.
io_type varchar(7) Type of pending I/O request. Is not nullable.
io_pending int Indicates whether the I/O request is pending or has been completed by Windows. An I/O request can still be pending even when Windows has completed the request, but SQL Server has not yet performed a context switch in which it would process the I/O request and remove it from this list. Is not nullable.
io_completion_routine_address varbinary(8) Internal function to call when the I/O request is completed. Is nullable.
io_user_data_address varbinary(8) Internal use only. Is nullable.
scheduler_address varbinary(8) Scheduler on which this I/O request was issued. The I/O request will appear on the pending I/O list of the scheduler. For more information, see sys.dm_os_schedulers (Transact-SQL). Is not nullable.
io_handle varbinary(8) File handle of the file that is used in the I/O request. Is nullable.
io_offset bigint Offset of the I/O request. Is not nullable.
io_pending_ms_ticks int Internal use only. Is not nullable.
pdw_node_id int Applies to: Azure SQL Data Warehouse, Parallel Data Warehouse

The identifier for the node that this distribution is on.


On SQL Server, requires VIEW SERVER STATE permission.
On SQL Database, requires the VIEW DATABASE STATE permission in the database.

See Also

Dynamic Management Views and Functions (Transact-SQL)
I O Related Dynamic Management Views and Functions (Transact-SQL)