Edit

dm_pdw_nodes_exec_query_statistics_xml (Transact-SQL)

  • Article

Applies to: Azure Synapse Analytics

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.

Remarks

The same remarks in sys.dm_exec_query_statistics_xml apply.

Permissions

Requires VIEW SERVER STATE permission on the server.

See also

Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)

Next steps

For more development tips, see Azure Synapse Analytics development overview.