| title | sys.dm_io_pending_io_requests (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/30/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | d1fb46dd-5c74-4c04-9ecf-8934b1bedb5b | ||||
| author | stevestein | ||||
| ms.author | sstein | ||||
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!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 | nvarchar(60) | Type of pending I/O request. Is not nullable. |
| io_pending_ms_ticks | bigint | Internal use only. 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_handle_path | nvarchar(256) | Path of file that is used in the I/O request. Is 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)