sys.dm_io_pending_io_requests (Transact-SQL)

APPLIES TO: YesSQL Server YesAzure SQL Database YesAzure Synapse Analytics (SQL DW) YesParallel Data Warehouse

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


To call this from Azure Synapse Analytics (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 nvarchar(60) Type of pending I/O request. Is not nullable.
io_pending_ms_ticks bigint Internal use only. 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_handle_path nvarchar(256) Path of file that is used in the I/O request. Is nullable.
pdw_node_id int Applies to: Azure Synapse Analytics (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 Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On SQL Database Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.

See Also

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