dm_pdw_nodes_exec_query_statistics_xml (Transact-SQL)
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.
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru