.png)
sys.dm_io_pending_io_requests (Transact-SQL)
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 (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. |
