| title | sys.dm_io_pending_io_requests (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/30/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | d1fb46dd-5c74-4c04-9ecf-8934b1bedb5b | ||||
| caps.latest.revision | 26 | ||||
| author | JennieHubbard | ||||
| ms.author | jhubbard | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-asdb-asdw-pdw_md]
Returns a row for each pending I/O request in [!INCLUDEssNoVersion].
Note
To call this from [!INCLUDEssSDWfull] or [!INCLUDEssPDW], 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 | 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 [!INCLUDEssNoVersion] 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. |
| pdw_node_id | int | Applies to: [!INCLUDEssSDWfull], [!INCLUDEssPDW] The identifier for the node that this distribution is on. |
On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
On [!INCLUDEssSDS_md] Premium Tiers, requires the VIEW DATABASE STATE permission in the database. On [!INCLUDEssSDS_md] Standard and Basic Tiers, requires the Server admin or an Azure Active Directory admin account.
Dynamic Management Views and Functions (Transact-SQL)
I O Related Dynamic Management Views and Functions (Transact-SQL)