sys.dm_pdw_sql_requests (Transact-SQL)
Applies to: 
Azure Synapse Analytics
Analytics Platform System (PDW)
Holds information about all SQL Server query distributions as part of a SQL step in the query.
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
request_id |
nvarchar(32) | Unique identifier of the query to which this SQL query distribution belongs.request_id, step_index, and distribution_id form the key for this view. |
See request_id in sys.dm_pdw_exec_requests. |
step_index |
int | Index of the query step this distribution is part of.request_id, step_index, and distribution_id form the key for this view. |
See step_index in sys.dm_pdw_request_steps. |
pdw_node_id |
int | Unique identifier of the node on which this query distribution is run. | See node_id in sys.dm_pdw_nodes. |
distribution_id |
int | Unique identifier of the distribution on which this query distribution is run.request_id, step_index, and distribution_id form the key for this view. |
See distribution_id in sys.pdw_distributions. Set to -1 for requests that run at the node scope, not the distribution scope. |
status |
nvarchar(32) | Current status of the query distribution. | Pending, Running, Failed, Cancelled, Complete, Aborted, CancelSubmitted |
error_id |
nvarchar(36) | Unique identifier of the error associated with this query distribution, if any. | See error_id in sys.dm_pdw_errors. Set to NULL if no error occurred. |
start_time |
datetime | Time at which query distribution started execution. | Smaller or equal to current time and greater or equal to start_time of the query step this query distribution belongs to. |
end_time |
datetime | Time at which this query distribution completed execution, was canceled, or failed. | Greater or equal to start_time, or set to NULL if the query distribution is ongoing or queued. |
total_elapsed_time |
int | Represents the time the query distribution has been running, in milliseconds. | Greater or equal to 0. Equal to the delta of start_time and end_time for completed, failed, or canceled query distributions.If total_elapsed_time exceeds the maximum value for an integer, total_elapsed_time will continue to be the maximum value. This condition will generate the warning "The maximum value has been exceeded."The maximum value in milliseconds is equivalent to 24.8 days. |
row_count |
bigint | Number of rows changed or read by this query distribution. | -1 for operations that do not change or return data, such as CREATE TABLE and DROP TABLE. |
spid |
int | Session ID on the SQL Server instance running the query distribution. | |
command |
nvarchar(4000) | Full text of command for this query distribution. | Any valid query or request string. |
For information about the maximum rows retained by this view, see the Metadata section in the Capacity limits topic.