sys.dm_io_pending_io_requests

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

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. 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.

Permissions

Requires VIEW SERVER STATE permission on the server.