| title | sys.dm_io_pending_io_requests (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_io_pending_io_requests (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 02/27/2023 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| ms.custom |
|
||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | >=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricsqldb]
Returns a row for each pending I/O request in [!INCLUDEssNoVersion].
Note
To call this from [!INCLUDEssazuresynapse-md] or [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_io_pending_io_requests. [!INCLUDEsynapse-analytics-od-unsupported-syntax]
| 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 (1) or has been completed by the operating system (0). An I/O request can still be pending even when OS 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. Value 0 = Pending SQL Server 1 = Pending OS |
| 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: [!INCLUDEssazuresynapse-md], [!INCLUDEssPDW] The identifier for the node that this distribution is on. |
On [!INCLUDEssNoVersion_md] and SQL Managed Instance, requires VIEW SERVER STATE permission.
On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools, the server admin account, the Microsoft Entra admin account, or membership in the ##MS_ServerStateReader## server role is required. On all other SQL Database service objectives, either the VIEW DATABASE STATE permission on the database, or membership in the ##MS_ServerStateReader## server role is required.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Dynamic Management Views and Functions (Transact-SQL)
I O Related Dynamic Management Views and Functions (Transact-SQL)