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. |
Permissions
Requires VIEW SERVER STATE permission on the server.