| title | sys.dm_pdw_nodes_exec_query_statistics_xml (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| description | Dynamic management view that returns query execution plan for in-flight requests. Use this DMV to retrieve showplan XML with transient statistics. | |
| ms.custom | ||
| ms.date | 10/14/2019 | |
| ms.prod | sql | |
| ms.technology | data-warehouse | |
| ms.reviewer | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | ||
| author | XiaoyuMSFT | |
| ms.author | xiaoyul | |
| monikerRange | =azure-sqldw-latest || = sqlallproducts-allversions |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-xxx-md]
Returns query execution plan for in-flight requests. Use this DMV to retrieve showplan XML with transient statistics.
| Column Name | Data Type | Description |
|---|---|---|
| node_id | int | Unique numeric ID associated with the node. |
| session_id | smallint | ID of the session. Not nullable. |
| request_id | int | ID of the request. Not nullable. |
| sql_handle | varbinary(64) | Is a token that uniquely identifies the batch or stored procedure that the query is part of. Nullable. |
| plan_handle | varbinary(64) | Is a token that uniquely identifies a query execution plan for a batch that is currently executing. Nullable. |
| query_plan | xml | Contains the runtime Showplan representation of the query execution plan that is specified with plan_handle containing partial statistics. The Showplan is in XML format. One plan is generated for each batch that contains, for example ad hoc [!INCLUDEtsql] statements, stored procedure calls, and user-defined function calls. Nullable. |
The same remarks in sys.dm_exec_query_statistics_xml apply.
Requires VIEW SERVER STATE permission on the server.
SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)
For more development tips, see SQL Data Warehouse development overview.