sys.dm_io_pending_io_requests (Transact-SQL)


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

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

System_CAPS_ICON_note.jpg Note

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

Column nameData typeDescription
io_completion_request_addressvarbinary(8)Memory address of the IO request. Is not nullable.
io_typevarchar(7)Type of pending I/O request. Is not nullable.
io_pendingintIndicates 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_addressvarbinary(8)Internal function to call when the I/O request is completed. Is nullable.
io_user_data_addressvarbinary(8)Internal use only. Is nullable.
scheduler_addressvarbinary(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_handlevarbinary(8)File handle of the file that is used in the I/O request. Is nullable.
io_offsetbigintOffset of the I/O request. Is not nullable.
io_pending_ms_ticksintInternal use only. Is not nullable.
pdw_node_idintApplies to: Azure SQL Data Warehouse, Parallel Data Warehouse

The identifier for the node that this distribution is on.

Requires VIEW SERVER STATE permission on the server.

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

Community Additions