Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns a row for each pending I/O request in SQL Server.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Data Warehouse Public Preview.
To call this from SQL Data Warehouse, use the name sys.dm_pdw_nodes_io_pending_io_requests.
Memory address of the IO request. Is not nullable.
Type of pending I/O request. Is not nullable.
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.
Internal function to call when the I/O request is completed. Is nullable.
Internal use only. Is nullable.
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.
File handle of the file that is used in the I/O request. Is nullable.
Offset of the I/O request. Is not nullable.
Internal use only. Is not nullable.
Requires VIEW SERVER STATE permission on the server.