dm_pdw_nodes_exec_query_statistics_xml (Transact-SQL)

Returns query execution plan for in-flight requests. Use this DMV to retrieve showplan XML with transient statistics.

Note

This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

Table returned

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. Is Nullable.
plan_handle	varbinary(64)	Is a token that uniquely identifies a query execution plan for a batch that is currently executing. Is 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 improvised Transact-SQL statements, stored procedure calls, and user-defined function calls. Nullable.

Requires VIEW SERVER STATE permission on the server.